Forum Discussion
How to avoid the 'dynamic data source' error during Power BI Service refresh
Hi Fern_21
The reason for this is because the url is based off parameters. It is not a defined. url that can be accessed. There is a work around for this in Chris Webb, blog post where he explains how to move those components to a different part of the URL. Chris Webb's BI Blog: Web.Contents, Text Concatenation And Dataset Refresh Errors In Power BI/Power Query
Hi GilbertQ !
Even following this concatenation logic with '&', I continue to receive the refresh issue on the Service.
How can I resolve ?
Thanks
Hi Fern_21, hello GilbertQ, thank you for your prompt reply!
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 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.
As a workaround, we suggest you store images on a public site.More information for your reference:
Data refresh in Power BI - Power BI | Microsoft Learn
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.