Invoke api call during data load not allowed to schedule refresh

[GRob]

During my data load i invloke a custom function that calls data from an api...

Source = Xml.Tables(Web.Contents("https://xxxxxx.com" & url))

I have hard coded the first part of the  url and passed through the variable url at the end which completes the api call.

I can run this without any issues in PowerBi desktop, but once published, I cannot auto refresh...

You can't schedule refresh for this dataset because the following data sources currently don't support refresh:

• Data source for OpenTickets

Discover Data Sources

Query contains unsupported function. Function name: Web.Contents

Any ideas?

[Greg_Deckler · Accepted solution]

@GRob 

When you use source parameter to get data dynamically in Power BI Desktop, it is not supported to refresh the dataset in Power BI Service, you would need to make changes to the M code as described in this similar blog: 

Dynamic Web.Contents() and Power BI Refresh Errors 

[GRob]

Thanks for the prompt reply. I followed your advice/links and ended up using the RelativePath method which works perfectly...

Source = Xml.Tables(Web.Contents("https://xxxxx.com",[RelativePath=url])),