See the attached. This is my problem. My datasources are an internal enterprise data warehouse running on SQL Server and a SharePoint site used to house Excel files that do not live in EDW.
I found the answer.
If I pull in just the EDW tables from SQL Server, I am able to schedule refresh.
If I pull in just the SharePoint tables from SQL Server, I am able to schedule refresh.
When I MERGE tables coming from SQL Server with those coming from SharePoint, I am NOT permitted to use data gateway or schedule a refresh.
When creating a solution in a way that does not require merging of these two tables, I am in good shape.
I found the answer.
If I pull in just the EDW tables from SQL Server, I am able to schedule refresh.
If I pull in just the SharePoint tables from SQL Server, I am able to schedule refresh.
When I MERGE tables coming from SQL Server with those coming from SharePoint, I am NOT permitted to use data gateway or schedule a refresh.
When creating a solution in a way that does not require merging of these two tables, I am in good shape.
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
