Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Create a Power BI PRO account and login (or use an existing).

  2. Install Power BI Desktop on any computer (recommended is the SQL server).
    https://powerbi.microsoft.com/en-us/desktop/

  3. Open the PBIX file and ensure that the data source is correct for the Insights database:
    The credentials must be "db_datareader" in both the Insights and DAM database.
    See: File→Options and Settings→Data source settings

  4. Publish to the Power BI account.

  5. Download and install the Power BI gateway on any computer (recommended is the SQL server).
    https://powerbi.microsoft.com/en-us/gateway/

  6. Setup the Gateway using the Power BI account and ensure that is is available in Power BI settings afterwards.
    You must use the same data source settings as defined in step 3.

  7. Go to the DataSet in Power BI and enable desired schedule for updating the online cube.

  8. Optional: Install Power BI Mobile:
    https://powerbi.microsoft.com/en-us/mobile/

...