Forum Discussion
Scheduled Refresh Error
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 ,
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.