Forum Discussion
Solved
Expression.Error: Access to the resource is forbidden when calling for function
Hello there, I have simple function to convert ip address to geolocation using https://api.ipstack.com/ service. When I call for function from query I receive error access forbiden. When I invoke f...
It was one EMPTY record in the column with IP addresses.
Expression.Error: Access to the resource is forbidden error is very misleading.
lbendlin
Super User
Super UserWhich privacy level did you select for that connection?
Note: You may not want to put your API key on the interwebs.
Yeah, I've noticed API key has been exposed, and I replaced my API key right away.
I tried each level, it returns the same error every time.
When I hit Apply in Power Query Editor I get this:
Invoked Function
Load was cancelled by an error in loading a previous table.
Locations
OLE DB or ODBC error: Exception of type 'Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenException' was thrown..
I've been using that model for years, never had a problem. I have no idea what changed and why.
- lbendlin
Which privacy level did you select for that connection?
I tried all of them: none, public, organizational and private.