Issue with data refresh for web service data - dynamic

[Anonymous]

Hi Team,

I am facing issue to refresh the data in power bi service.

I am using web service to fetch the data and it is working fine in power bi desktop. I created a power query functions to pass s values from a table dynamically and  join together for reporting.

I am able to refresh if i give direct link without using function which generate the web service dynamically by passing the column value.

I think the issue is because power bi tried to validate the web service url and it fails since until the value is passed from the column to make complete url.

Error

"Query contains unsupported function. Function name: Web.Contents"

Any help on this.

Br,

Shams

[Anonymous]

@Anonymous You are correct, it is due to validating the URL. There is a way to trick Power BI into verifying it, this is the most comprehensive blog I've read on the topic -> https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power-bi/

Depending on how complex the function is, I hope the above works for you, but I've had similiar challenges that remain unresolved.