Excel files / folders only but getting the dynamic datasources 'error' - which cannot be refreshed

[Jtbonner1986]

Hi there,

i have recently scheduled a PBIX report and i am trying to schedule the job for auto refresh but am getting the error:

This report contains dynamic datasources, which cannot be refreshed in Power BI Report Server

However, the file doesnt contain and webcontents and only refreences files in the local ecosystem. Any ideas?? 

[Anonymous]

Hi, @Jtbonner1986 
 It's been a while since we last interacted. Has your issue been resolved? If our answers did not solve your problem, please let us know the shortcomings of our solution.

If our answers have helped you, please accept the answer you found effective as the solution. This will help many community members with similar issues.

Of course, if you have your own solution, feel free to share it with us. Looking forward to your response, thank you in advance!

Best Regards,

Leroy Lu

[Jtbonner1986]

Hi, Sadly we are on the on premise version so this is not a valid option...

[Anonymous]

Hi, @Jtbonner1986 
Thanks for reaching out to the Microsoft fabric community forum.

Indeed, as mentioned in the documentation, data used in reports to dynamically construct server names, database names, or URLs are considered dynamic data sources. However, these data sources may not be visible in the data source settings.

The official documentation states that only data sources detected when the report is uploaded can be refreshed. Below is a screenshot of our test results:

This error also exists in the screenshot you provided.Typically, if your data source only contains dynamic data sources, it cannot be configured for refresh in the report server.The data source configuration credentials section is grayed out.

The reason you can configure the refresh is that your data source includes non-dynamic data sources. Below are our test results for a project that includes both dynamic and refreshable data sources. This project can be configured for refresh, but the refresh fails, similar to the issue you encountered:

For more details, please refer to the documentation:

 https://learn.microsoft.com/en-us/power-bi/report-server/scheduled-refresh#when-scheduled-refresh-ca...

You can try using the RelativePath and query options in conjunction with the Web.Contents M function. This approach can also refresh queries that reference Power Query parameters.
For more details, please refer to the documentation:

Solved: Scheduled Refresh using Dynamic Data Source - Microsoft Fabric Community

Solved: This report contains dynamic datasources, which ca... - Microsoft Fabric Community

Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.