Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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?
Solved! Go to Solution.
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 refres...
[solved] Power BI “This dataset includes a dynamic data source. Since dynamic data sources aren’t re...
Also, 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 Community
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.
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.
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.
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 refres...
[solved] Power BI “This dataset includes a dynamic data source. Since dynamic data sources aren’t re...
Also, 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 Community
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.
hi @b1234 ,
try the blog below found online.
https://tengkuma.vercel.app/blog/posts/conquering-urls-with-relativepath-and-query-in-power-bi
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
34 | |
32 | |
19 | |
12 | |
8 |
User | Count |
---|---|
52 | |
36 | |
29 | |
14 | |
12 |