April 5, 2021
has anybody else come across this error?
I recently imported data from a website into power query and it was working fine for a few days and now it's not.
I'm getting this error: Expression.Error: Access to the resource is forbidden.
None of the tips found on google are fixing the problem.
I've tried changing settings. I've been back through Mynda's videos. I've searched the forum. I can't figure it out.
Would be much appreciated if anyone has a solution.
December 7, 2016
Do you access the site data with user credentials?
Did it stop working after you changed or added a step?
Does it work if you create a new query?
In general, this error is most likely related to user credential issues, for example non-valid password or trying to access parts of data the user don’t have permission to access, for example SharePoint list meta data.
To troubleshoot, make a copy of your query and with the copy check each step from bottom up to see where it breaks. If you have this error even on your first step and you have typed in user name and password in order to access the data, type in the password again.