Forum Discussion

MaryBadAbda's avatar
MaryBadAbda
New Member
7 months ago
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...
Need Help
  • MaryBadAbda's avatar
    MaryBadAbda
    7 months ago

    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:

    1. In Gateway settings, I enabled:
      "Allow user's cloud data sources to refresh through this gateway cluster"

    2. Set Privacy Level = Organizational for both data sources:

      • In Power BI Desktop

      • And in the Service under Gateway > Data source settings

    3. Re-published the report.

    Now the scheduled refresh works fine.
    Hope this helps someone else!

v-priyankata's avatar
v-priyankata
Community Support
7 months ago

Hi MaryBadAbda 

Thank you for reaching out to the Microsoft Fabric Forum Community.

d_m_LNK GilbertQ Thanks for the inputs.

I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.