Forum Discussion
Scheduled Refresh Error
I'm having trouble scheduling a refresh in Power BI. I have a report template with data from both a Web API and an SQL Server. After publishing the report to Power BI Service, I'm encountering errors when trying to set up the refresh schedule.
Can anyone provide guidance or advice on how to properly configure and schedule these refreshes?
Hi b1234 ,
Don't use dynamic URLs when using Web.Contents, just put the entire url in as a string and it will refresh. Also, note that the brackets around the variable are unnecessary, as well as the syntax for concatenating URL parameters.
Power BI - Solution to 'This dataset includes a dynamic data source ... this dataset won't be refreshed.' | Jon Gallant
[solved] Power BI “This dataset includes a dynamic data source. Since dynamic data sources aren’t refreshed in the Power BI service” | FlowpointAlso, here are some threads similar to yours that I hope will help you.
Solved: This dataset includes a dynamic data source. Since... - Microsoft Fabric Community
Solved: Dynamic data sources aren't refreshed in the Power... - Microsoft Fabric CommunityBest Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
hi b1234 ,
try the blog below found online.
https://tengkuma.vercel.app/blog/posts/conquering-urls-with-relativepath-and-query-in-power-biHi b1234 ,
Thanks for the reply from mohitkumawat , please allow me to provide another insight:
In most cases, Power BI semantic models that use dynamic data sources can't be refreshed in the Power BI service. There are a few exceptions in which dynamic data sources can be refreshed in the Power BI service, such as when using the RelativePath and Query options with the Web.Contents M function. Queries that reference Power Query parameters can also be refreshed.
To determine whether your dynamic data source can be refreshed, open the Data Source Settings dialog in Power Query Editor, and then select Data Sources In Current File. In the window that appears, look for the following warning message, as shown in the following image:
If that warning is present in the Data Source Settings dialog that appears, then a dynamic data source that can't be refreshed in the Power BI service is present.
Data refresh in Power BI - Power BI | Microsoft Learn
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous,
The warning message is not showing for any of the data sources:
Hi b1234 ,
Don't use dynamic URLs when using Web.Contents, just put the entire url in as a string and it will refresh. Also, note that the brackets around the variable are unnecessary, as well as the syntax for concatenating URL parameters.
Power BI - Solution to 'This dataset includes a dynamic data source ... this dataset won't be refreshed.' | Jon Gallant
[solved] Power BI “This dataset includes a dynamic data source. Since dynamic data sources aren’t refreshed in the Power BI service” | FlowpointAlso, here are some threads similar to yours that I hope will help you.
Solved: This dataset includes a dynamic data source. Since... - Microsoft Fabric Community
Solved: Dynamic data sources aren't refreshed in the Power... - Microsoft Fabric CommunityBest Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi b1234 ,
Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
