Forum Discussion
Solved
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 p...
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:
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])),