Remove Dynamic queries

[andreanidouglas]

How am I supposed to remove the dynamic query as per message below? There is no "Query1" in my model.

Is it the function table being classified as dynamic? Since it uses a Uri.Combine to build the url to Web.Content? This function is called once per row of a table, to get details of a transaction.

[Anonymous]

Hi @andreanidouglas 

Right now this type of data source is not supported to refresh in the Power BI Service.

What you can do as a workaround is to use the relative path option as shown below

Setting a scheduled refresh on a Dynamic Data Source in Power BI | by dataninja | DataDrivenInvestor

Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query An...

Please try to refer to the following topic for more information.

https://community.powerbi.com/t5/Service/Not-Able-to-Refresh-the-Dataset-You-Can-t-schedule-refresh-...

Best Regards

Community Support Team _ Polly

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

[andreanidouglas]

The solution presented in the blog, does not apply in my case.

On the query inventory header, I got a reference id of items. These Ids are used in a custom function to call an API to retrieve detailed information of each inventory item.

The Api call is then build by using a base url, the inventory id and some additional parameters (per 3rd image above).

[GilbertQ · Accepted solution]

Hi @andreanidouglas 

Yes it is because the URI is changing which is making it dynamic.

You could try the following blog post from Ken Puls which might overcome your issue: https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/