Refresh problem

[RafalGabin]

Today after adding excel file from Sharepoint merged with data from MS SQL Server (data from MS SQL Server connected throught gateway on server) I noticed error when I wanted to refresh data:

{"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"Cloud data source refresh is not allowed in gateway setting."}}],"exceptionCulprit":1}}}

I have other files from Sharepoint added, and also from same Sharepoint (all cloud connection). Before was no problems, those files from Sharepoint are not merged, I needed to add another one today which I needed to merge with table from MS SQL Server.
How to fix this so sheduled refresh can run without this error?

[v-tejrama]

Hi @RafalGabin ,

Thank you @Zanqueta , @MasonMA and @rohit1991 for the helpful input!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you for your support!

[MasonMA]

Hi, 

I'd recommend having a look at these posts and enabling 'Allow User's cloud data source to refresh'

https://community.fabric.microsoft.com/t5/Service/Cloud-data-source-setting-is-not-allowed-refresh-t... 

https://community.fabric.microsoft.com/t5/Service/Power-BI-gateway-refresh-error/m-p/2075326 

[ritaok]

Hello PowerBi Experts, 

I have following this issue can someone please guide how to solve this issue in service.

I currently have my data connected through 3 sources: SQL, Sharepoint and Odata (for my HRIS system). And during refresh i keep getting this error message. I read other posts that recommended adding sharepoint as a gateway but is that applicable in this case since i have a 3rd connection. 

I appreciate the guidance 

[rohit1991 · Accepted solution]

Hii @RafalGabin 

That error appears because your dataset now mixes a cloud source (SharePoint) with an on-prem SQL Server (gateway) and the gateway is not configured to allow cloud data source refresh in mixed-mode queries. When you added the new Excel file and merged it with SQL Server, the model became a “combined” data source, and the refresh is blocked.
To fix it, go to Gateway >> Settings >> Allow user cloud data sources to refresh through this gateway and enable it (or move the SharePoint file into a Dataflow so the dataset only refreshes from the gateway). Once the gateway allows cloud + on-prem mixing, your scheduled refresh will work again.

[Zanqueta]

Hi @RafalGabin,

I guess this error occurs because you are attempting to combine a cloud data source (SharePoint) with an on-premises source (SQL Server via Gateway) within the same dataset. 

The message “Cloud data source refresh is not allowed in gateway setting” indicates that the SharePoint source is treated as cloud, while the model is configured to use the Gateway for SQL Server.

How to resolve this
There are two main approaches:

Option 1: Configure all sources in the Gateway

1. In Power BI Service, go to Dataset Settings > Gateway.
2. Add the SharePoint connection to the Gateway (even though it is a cloud source, it can be configured as a gateway source).
3. Ensure that:
   • The SharePoint URL used in Power BI Desktop matches exactly the one configured in the Gateway.
   • Credentials are correctly set.
4. Associate both sources (SQL Server and SharePoint) with the same Gateway.

---

Option 2: Avoid using the Gateway for cloud sources

• If possible, remove the Gateway dependency for SQL Server by using Azure SQL Database or Dataflows.
• Alternatively, keep the Gateway only for SQL Server and ensure that SharePoint remains a direct cloud connection without being forced through the Gateway.

---

Best practices

• For hybrid scenarios (cloud + on-premises), consider using Dataflows to load SharePoint data separately and then combine it within the service.
• This reduces complexity and avoids refresh errors.

Official documentation:

On-premises data gateway - Power BI | Microsoft Learn

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.