Forum Discussion
Automatic Refresh on dynamic data sources - SharePoint
Hi Stephen,
I think you may have misinterpreted the question. This does not have to do with credentials; there is a dynamic query at the 'GetList' action. I am unable to schedule an automated refresh due to this reason and received an error stating as much.
In any case, I was able to resolve by using Chris Webb's method of Json.Document source and Web.Contents to use relative paths so that the Source Url could continue to be read and I can iterate throughout all my subsites and aggregate all lists.
can you share the link to the "Chris Webb's method of Json.Document source and Web.Contents" thanks
Hi!
This is the Chris's blog: - https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/
I was also able to solve the problem using this.