Scheduled Refresh Error

[b1234]

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?

[v-kaiyue-msft]

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]

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.

[b1234]

Hello @v-kaiyue-msft,

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

[v-kaiyue-msft · 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.

[mohitkumawat]

hi @b1234 ,

try the blog below found online. 
https://tengkuma.vercel.app/blog/posts/conquering-urls-with-relativepath-and-query-in-power-bi