Forum Discussion
Anonymous
5 years agoNot applicable
[Refresh on Power BI Service][MySQL]
Dear Power BI community, I have connected my Power BI Desktop file with Sharepoint and an external remote MYSQL server, Now I would like to publish it to the Power BI Service, and have scheduled...
V-lianl-msft
5 years agoCommunity Support
Hi Anonymous ,
If your dataset not only contains cloud data source but also the on premise data source, then it needs to use the gateway and configure schedule refresh, see more: :On-premises data gateway , Configure scheduled refresh .
Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.