Forum Discussion
Can't refresh power bi
Hi,
In power bi service I am getting this:You can't schedule refresh for this semantic model because the following data sources currently don't support refresh. Data source for Query1
How to resolve this?
3 Replies
- lbendlin
Super User
Show the (sanitized) Power Query code.
- AnonymousNot applicable
Hi Analitika ,
lbendlin Thanks for your concern about this case! We can try the following more detailed steps:First, we need to confirm the data source that is causing the refresh issue. You can do this by following these steps in Power BI Desktop:
1. Select Transform data from the ribbon bar.
2. Choose Advanced Editor.
3. Note the provider listed for the source.
Once you've identified the data source, compare it against the list of supported data sources for Power BI refresh operations. You can find the list of supported data sources in the Power BI documentation here:
Power BI data sources - Power BI | Microsoft Learn
If the data source is listed as supported but you're still facing issues, ensure that all necessary drivers or gateways are correctly installed and configured.
For data sources not supported for direct refresh, consider using a different approach such as importing data into a supported database or using Power BI dataflows as an intermediary step.
Please review the specific connector documentation in Power Query for any limitations or additional configuration steps:
List of all Power Query connectors - Power Query | Microsoft Learn
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. - Digger
Post Patron
RelativePath problem in 90%