Forum Discussion
Scheduled Refresh from MS-SQL Database into Power BI Desktop
Hi, My Power BI Desktop is connected to an MS-SQL database. I am using the Import connection method to pull in a selection of tables from that database. I can manually refresh the imported data...
Hi Anonymous
As far as i known,
Power BI Desktop don't support Schedule Refresh currently.
It supports to refresh on schedule from Power BI Service directly to data source.
When schedule refresh works on Power BI Service, it send queries back to the data source (MY-SQL database in your case),then get lastest data from the database and display it on Power BI Service dashboards or reports.
So the flow for schedule refresh is
MS-SQL --> Gateway-> Power BI online server
To learn how to configure scheduled refresh, see Configure scheduled refresh.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.