Refreshing Data on Power Query from SharePoint Error: How to fix?

[Anonymous]

Hi folks,

For months now, I've been the only person who has been manually extracting data and placing it in our SharePoint folder. Anytime I'm asked to refresh data, I extract from tool, save in SharePoint folder under same name, then open Power Query and refresh. I've had no issues doing this.

Recently, we onboarded a new team member who also wants to refresh this data. When he tries to do so, he gets errors regarding privacy levels/etc. Last time he tried, this window came up asking about the Privacy levels and he hit "Ignore Privacy Levels", but still has the same issue.

Here is the error that comes up on his end:

He has access to this folder in SharePoint. Does anyone have any suggestions?

[amitchandak · Accepted solution]

@Anonymous , refer if these two can help

https://answers.microsoft.com/en-us/msoffice/forum/all/microsoftmashupengineinterfaceresource-access/dd932d2b-5494-4804-9af2-1ebe185d528c

https://social.technet.microsoft.com/Forums/lync/en-US/489bc601-afac-4c72-9614-4090632996c3/microsoftmashupengineinterfaceresourceaccessforbiddenexception?forum=powerquery

[Anonymous]

Thank you so much. This is great.