Installing Digizuite™ Insights
The Digizuite™ Insights module is installed using Powershell. The Package, provided by the Digizuite DAM Vendor is a zip file with the following structure:
NOTE
If Datasynchronziation in PowerBI fails with cyclic reference errors - use pbix file from 5.6.1
OR modify the 5.6.o pbix file as follows
the issue is newer PowerBI Apps do not allow the parameterName Schema - Select Transform Data, and rename the parameters (left pane)
- Database → parDatabase
- Schema → parSchema
- Server → parServer
Click Close & Apply + Refresh
1.1 How to Install
To install the Digizuite™ Insights module, do the following:
- Edit Install.ps1, see Section 1.2 for a description of all the parameters
- Run the Install.ps1, as administrator, either from Powershell or the PowerShell ISE
1.2 Variables
| Variable | Mandatory | Description |
|---|---|---|
| ConnectionStringMaster | True | ConnectionString to Master Database on the SqlServer that should contain the Insights Database |
| ServicesFolder | True | The path where Insights service should be installed |
| connStrDam | True | Connection String to Dam Database (copy from Dam site Web.config) |
| damSiteFQDN | True | Fully qualified Domain Name of the Dam Center |
| DbName | True | Database Name of DamCenter Database |
| InsightsDbPassword | True | SQL Password for Insights User |
| LogRoot | False | Root folder for LogFiles |
Troubleshooting
Per default, PowerBI will try to logging as a Windows user.
If you wish to log in with the generated MS SQL user instead,
File → Options and settings → Data source settings
Add your user, and then press: Edit permissions
Under Credentials, press Edit
Select Database, beneath Windows, l and add your login credentials here
Now, you should be fully prepped for logging in to PowerBi.