March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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:
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?
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.
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.
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
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.