Forum Discussion
AutoRefresh Cloud Dashboard from local database
Dear all,
I'd like to refresh a O365 Cloud PowerBI Dashboard where the data is stored in a database in my private datacenter.
Right now I connect the database via VPN, open the PowerBI App and click refresh and publish.
I have the possibility to run any service on the local database server so the VPN is not needed anymore.
My goal is to have a scheduled job on my windows server that executes the described steps.
Can anybody please help me how to achieve this?
Thank you in advance
Regards
Christian
Hi Anonymous
I think you can refer to this official article for help: https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial
- Create and publish a Power BI Desktop (.pbix) file that imports data from an on-premises SQL Server database.
- Configure data source and dataset settings in Power BI for SQL Server connectivity through a data gateway.
- Configure a refresh schedule to ensure your Power BI dataset has recent data.
- Perform an on-demand refresh of your dataset.
- Review the refresh history to analyze the outcomes of past refresh cycles.
- Clean up resources by deleting the artifacts created in this tutorial.
2 Replies
Hi Anonymous
I think you can refer to this official article for help: https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial
- Create and publish a Power BI Desktop (.pbix) file that imports data from an on-premises SQL Server database.
- Configure data source and dataset settings in Power BI for SQL Server connectivity through a data gateway.
- Configure a refresh schedule to ensure your Power BI dataset has recent data.
- Perform an on-demand refresh of your dataset.
- Review the refresh history to analyze the outcomes of past refresh cycles.
- Clean up resources by deleting the artifacts created in this tutorial.