Forum Discussion
Proper way to create report that hooks up to Azure SQL Server DB
So, this whole thing is confusing to me, and the forums appear to have conflicting answers based on when the post appears. My company has a SQL Server Database in Azure. I have downloaded Power BI De...
Cliff notes:
1. Install the Enterprise Gateway - it is the plumbing for everything.. you then configure the credentials for the report to use in the gateway.
2. Open Power BI.. click on the "Settings" gear.. select settings, Select the dataset tab - this is where you associate the dataset to the gateway and schedule the refresh.
3. Click on the dataset name.. you will see "Gateway connection" and "Schedule Refresh". Note direct query can only be scheduled hourly.
We have an Azure virtual running SQL. The Enterprise Gateway is installed on this machine. We created a common user to use to upload the reports to the service.