Forum Discussion
Solved
Refresh failure: Cloud data source refresh is not allowed in gateway setting
Hello, I am experiencing an issue with automatic refresh in Power BI Service. Cloud data source used: Google Analytics (OAuth 2.0) Error message received during scheduled refresh: {"error":{"co...
Hello!
Thank you for your help, d_m_LNK and GilbertQ.
The issue was caused by combining cloud data sources (Google Analytics and Meta Ads) using Append in Power Query. This triggered a refresh failure in the Power BI Service with the error: "Cloud data source refresh is not allowed in gateway setting."
Solution:In Gateway settings, I enabled:
"Allow user's cloud data sources to refresh through this gateway cluster"Set Privacy Level = Organizational for both data sources:
In Power BI Desktop
And in the Service under Gateway > Data source settings
Re-published the report.
Now the scheduled refresh works fine.
Hope this helps someone else!
