...
- Microsoft™ SQL Server 2014 or higher with an existing DAM installation.
- To use the Power BI reporting service, at least one Power BI PRO account with configured on-premises data gateway.
- Digizuite™ Insights files: Database installer and the Power BI file.
| Note |
|---|
When creating SQL logins (or using integrated) it is important that the user only has read access (db_datareader) to the DAM database. |
| Note |
|---|
Inside the PBIX file there is a stored data source. It is important that this data source (SQL server and credentials) is the same as the one used in the Power BI data gateway. |
Database installation / update
...
- Create a Power BI PRO account and login (or use an existing).
- Install Power BI Desktop on any computer (recommended is the SQL server).
https://powerbi.microsoft.com/en-us/desktop/ - Open the PBIX file and publish and ensure that the data source is correct for the Insights database:
File→Options and Settings→Data source settings - Publish to the Power BI account.
- Download and install the Power BI gateway on any computer (recommended is the SQL server).
https://powerbi.microsoft.com/en-us/gateway/ - 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. - Go to the DataSet in Power BI and enable desired schedule for updating the online cube.
- Optional: Install Power BI Mobile:
https://powerbi.microsoft.com/en-us/mobile/
...