Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Query contains unsupported function. Function name: Web.Contents
Any ideas?
Solved! Go to Solution.
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
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
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])),
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |