Solved: Impossibility to refresh data

Anonymous · ‎10-01-2020

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 · ‎10-01-2020

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/

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

View solution in original post

GilbertQ · ‎10-01-2020

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/

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog