Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
b1234
New Member

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.

 

b1234_0-1720608867747.png

b1234_1-1720608942135.png

 

Can anyone provide guidance or advice on how to properly configure and schedule these refreshes?

1 ACCEPTED 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.

View solution in original post

5 REPLIES 5
v-kaiyue-msft
Community Support
Community Support

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.

v-kaiyue-msft
Community Support
Community Support

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:

 

vkaiyuemsft_0-1720663224768.png

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 @v-kaiyue-msft,

 

The warning message is not showing for any of the data sources:

b1234_0-1720679994367.png

 

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.

mohitkumawat
Super User
Super User

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.