Impossibility to refresh data

[Anonymous]

Hi i've just published my report on powerbi.com. But, when I try to refresh my data i have this error message : This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more: https://aka.ms/dynamic-data-sources.

• Data source for Query1.

I am getting my data from log analytics and excel files (which are stored on my local drive C)

Does anyone know how to fix this ? 

[GilbertQ · Accepted solution]

Hi there

It is because Power BI cannot validate the URL of the query. You have to make the URL static and then use the Relative Path Dynamic

You will have to look at the link and have to change the underlying query.

Or here is a way to get it working
http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/