Forum Discussion
Error Refreshing with Dual Connection - SQL via Gateway and SharePointList via Cloud Connect
Check if this option is set on your gateway
Merge or append on-premises and cloud data sources - Power BI | Microsoft Learn
But in general you don't need a gateway for Sharepoint sources. What version of the gateway are you running?
You can try the steps below. This issue usually happens when a cloud data source is still accidentally tied to the on-premises gateway.
The error message:
“Cloud data source refresh is not allowed in gateway setting”
basically means that your SharePoint Online source is being routed through the gateway, which isn’t supported in Fabric / Premium. SharePoint needs to refresh directly through a cloud connection, not via a gateway.
Try Below Steps:
1. Remove SharePoint from the Gateway
- Go to Power BI Service → Manage connections and gateways
- Open your gateway
- Under Data Sources, delete the SharePoint / Web / OData entry
2. Connect SharePoint as a Cloud source
- Open your Semantic Model → Settings → Data source credentials
- Sign in to SharePoint using your Organizational Account
- Make sure:
- Gateway = Not used
- Connection type = Cloud
3. If it still keeps using the gateway
Sometimes this happens if the SharePoint source was created using Web/OData in Power BI Desktop.
In that case:
- Recreate the source using Get Data → SharePoint Online List
- Republish the model and re-enter your credentials
Once SharePoint is fully disconnected from the gateway, the scheduled refresh should work without errors.