Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Unable to setup scheduled refresh for supported data sources

Hi,

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?

5 REPLIES 5
v-rzhou-msft
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. 

Anonymous
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. 

Anonymous
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.

 

Thanks

John

GilbertQ
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

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors