Forum Discussion
Self Sourcing Query and Data Refresh issue - Excel
So, here is what I am trying to accomplish: I have a tool, that exports a list of cases that an engineer closed. Things include case number, time, etc. The tool goes back 180 days. If I w...
Just changed Privacy settings to NONE for everything.
Still same result.
So I tried to go back and modify the datasource EXACTLY how it says in the article I posted.
When I change the source of the duplicate from this:
= Excel.Workbook(Web.Contents("https://microsoft-my.sharepoint.com/something/something/something/something/ClosedCases.xlsx"), null, true)
and change it, I get the following errors, depending on how I change it: