Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

Unable to setup scheduled refresh for supported data sources


Since yesterday I'm unable to setup scheduled refreshes for new (supported data source) content - in this case an Excel report using Power Query to access an MS/SQL database:


You can't schedule refresh for this dataset because the following data sources currently don't support refresh:

  • Data source for WH v_GetContractBookStockForDashboard

The data source in question is a view for an on-premise MS/SQL database - the file itself uploads OK to Power BI. Existing reports in the Power BI service using the same database are continuing to refresh OK, according to their previous schedules - they are using a Personal Gateway running on a VM under my AD account.


So, I made a copy of one of these reports and tried to upload it again to the Power BI service and got exactly the same error when trying to schedule refresh. I've also tried to upload other reports using alternative supportd data sources (Web, Active Directory, etc.) and in each case get the same "unsupported data source" error. So, it appears I can't setup scheduled refresh for "any" support data source.


I'v update the gateway SW to the latest version (to no avail) and nothing else in our M365 tenant has changed. Any ideas or suggestions for how to troubleshoot?

Community Support
Community Support

Hi @Anonymous 

Did you use import connection mode to build your report?


Personal Gateway only support import connection mode. 


Could other reports scheduled refreshed successfully?


Try to refresh your report in your desktop.


If refresh failed in desktop, please check your datasource in Data Source Setting.

Troubleshooting: Troubleshooting unsupported data source for refresh


Please check if you just retrieved data, do you do any steps in Query Editor, eg: Append Queries, Merge Queries? Please try to run the latest desktop version. 


If refresh succeed in desktop, please try Enterprise gateway and it is better to install your gateway in the same PC with your data source.


Personal Gateway and Enterprise gateway:On-premises data gateway vs. on-premises data gateway (personal mode)

I found a post with the issue like yours: Data sources don't support refresh


Best Regards,

Rico Zhou


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Not applicable

Just as an update, I created the equivalent report, using exactly the same data source (Import mode) in Power BI Desktop and was able to setup refresh OK, so problem seems to be specific to Excel?

Hi @Anonymous 

Could you configure schedule refresh successfully when you publish the equivalent report to Service, using exactly the same data source?

Try to republish the report to service again.

Is this report get data source from MS/SQL database and Excel?

I found a post with the issue like yours: Data sources don't support refresh


Best Regards,

Rico Zhou


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Not applicable

Hi @v-rzhou-msft 

Yes, that's correct. I Basically copied the existing M code from the Excel-based report (which doesn't work) and pasted it into the Advanced Editor in PBI Desktop, then created a simple table visual of the data from this. I published the PBIX file to the PBI Service and was able to schedule refresh no problem. The reason I'm using Excel is that the report is a Pivot table which works best for what I need to do - it is only getting data from a standard MS/SQL View, no other sources:


Source = Sql.Databases("itl-tascsdb01\itl_tascs"),
WAREHOUSE = Source{[Name="WAREHOUSE"]}[Data],
WH_v_GetContractBookStockForDashboard = WAREHOUSE{[Schema="WH",Item="v_GetContractBookStockForDashboard"]}[Data],


I'm now waiting on Microsoft 3rd-level support to call me back.




Super User
Super User

Hi @Anonymous 

Can you go into your Power BI Desktop file, click on Data Sources and if it shows you that some data sources are hand authored that means it will not be refreshed in the Power BI Service.


You will then need to go into the Power Query Editor and see which query is causing the issue and then fix it!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors