Forum Discussion
Invoke api call during data load not allowed to schedule refresh
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
Query contains unsupported function. Function name: Web.Contents
Any ideas?
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:
2 Replies
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:
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])),
