Forum Discussion
Self Sourcing Query and Data Refresh issue - Excel
I will add that under permissions for the datasets, privacy was set to None.
I changed this to Organizational for each of them.
Again, updates on Desktop, but errors in Service.
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:
Bumping this as I am stuck.
I have been messing with this all day.
I could really use some help on this.
Again, my objective is to keep a running log.
I had the same problem, I tried all the solutions described above and they didnt work, what worked for me was publishing the report and dataset to a new workspace that I created as an admin after finding out that I was a member on the previous workspace.
