Deploy Gizmo Analytics Power BI Reports
GSX Gizmo Analytics leverages Microsoft Power BI Desktop to publish dashboards. This procedure explains how to use Power BI templates.
Power BI License
In order to publish the report the publisher requires a Power BI license. A “Power BI Pro” is recommended for sharing the report in a team.
The machine used for Power BI Desktop should follow the below requirements:
8GB of RAM (16GB recommended for large deployments)
Always use the latest stable version of the Microsoft Power BI Desktop
Supported refresh frequency is 4 hours during business hours
Default data retention is 6 months (180 days)
Always use the latest version of the Gizmo Analytics Power BI Template
Importing data in your report
Download and install Power BI Desktop
Download the Power BI template (.pbit file) provided by GSX.
Power BI Desktop is running.
Click the link to enter your Power BI license associated with your Office 365 account on the next screen.
Now you are connected under your use account.
Enter the SQL Server and Database in the required fields (Use 01/01/2020 and 01/01/2025 RangeStart and RangeEnd)
Choose “Database” and enter the credentials that were provided to you
Now the template is loading data from the SQL Server.
After a few minutes of data import the report should load:
You can then publish this report to a workspace in your Power BI Service Online.
Publishing the report to Power BI Service
In order to publish the template you must have a workspace existing in Power BI (how to create a workspace) and then:
From Power BI Dekstop click “Publish“
Select the workspace where you wish your Team to access the Gizmo data:
Wait until it is available online:
Once fully ready click the link and share the dashboard with your Team!