Download and Install PowerBI on the SQL server
Configure PowerBI to point to the Insights database
Populate the report with Insights data
Publish the report to the PowerBI service
Download and Install the data gateway
Configure a scheduled refresh
You can download PowerBI using this link https://www.microsoft.com/en-us/download/details.aspx?id=58494
How to Configure PowerBI to point to the Insights database
After installation open PowerBI and login with the customer credentials
The next step is to open the PBIX file (Insights report) in PowerBI
the simplest way is to double click the PBIX file, or from Power BI Desktop click File, Open and browse to the file location This will load the PBIX in to Power BI Desktop
Click on File>Options and settings>Data Source settings
Now we need to change the source to point to the Insights database
In the Data source settings dialogue box, right click the current source and select Change Source
In the SQL Server database type the Servers IP address and the database name and click OK
Right click the source again and select Edit Permissions
In the Edit Permissions dialogue box Under Credentials click Edit
In the dialogue box, select Database in the left hand panel, then enter the Username and password for the login you created earlier on the SQL Server, then click Save.
Click OK and click Close
In Power BI Click Refresh to update the data loaded in the PBIX file/template
Your dataset is now loaded, the next step is to Publish this to the Power BI Service
From the ribbon in Power BI Desktop click Publish, you will be prompted Do you want to save your changes ?
Click Save
You will be prompted to Select a destination to Publish to, make your choice and click Select.
The process will now run
Once completed your are presented with the following dialogue box
Now click on Open Digizuite Insights.pbix in Power BI to open the browser based version of Power BI
From the Power BI Service/Portal select downloads, then data gateway
Click on the Download Gateway button
After the download has completed, browse to the files location, right click the application and select Run as administrator
Click Next in the On premises data gateway installer dialogue box
After choosing On-premises data gateway (personal mode) option, click Next
The installer will start preparing the installation files
Click Next in the Reminder befor you install dialogue box
In the next dialogue box, choose an install location or accept the default, click to accept the terms of use and privacy statement, then click Install
The installation will now begin
After the installation is completed you will be prompted to enter an email address to be used with the gateway, then click sign in
Enter the customers login credentials in the EnterpriseGatewayConfigurator box and click OK
Next you will need to register the gateway, assign the gateway a name, input a recovery key, add to an existing gateway cluster if one exists and click Configure.
After the configuration is completed you will see the follwoing dialogue box, click Close
To configure the gateway, click the settings cog in the Power Bi Service portal, then click Manage gateways
On the Gateway Cluster Settings page, select your gateway and click Add data source to use the gateway
In the Data Source Settings complete the Data Source Name, Select the Data Source Type, Server IP Address, Database Name and Select an authentication method and click Add
Once the connection has been setup the following dialogue box will be displayed
The gateway is now ready for use.
How to Schedule the Refresh of Data
Login to the PowerBI Service, navigate to Datasets and click on the 3 dots next to the Dataset
Click on Schedule refresh enable the feature and configure the Frequency and Time zone, click Add another time and set the time of refresh, then click Apply.
Now the data will refresh each day at the configured time