Forum

Expression.Error: A...
 
Notifications
Clear all

Expression.Error: Access to the resource is forbidden.

2 Posts
2 Users
0 Reactions
411 Views
(@matorr)
Posts: 4
Active Member
Topic starter
 

Hi,

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.

Thanks

Mat

 
Posted : 14/12/2021 10:36 pm
Anders Sehlstedt
(@sehlsan)
Posts: 970
Prominent Member
 

Hello,

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.

Good luck.

Br,
Anders

 
Posted : 15/12/2021 5:57 pm
Share: