Power BI Connector: 'Expression.Error: Access to the resource is forbidden.'

Alex Feuchtwanger

Hello,

I followed the excellent tutorial from Linton about creating the connector, but when I try to load a table I get the error ‘Expression.Error: Access to the resource is forbidden.’ I have given my app Full data access, and I have tried clearing and recreating the connection as well as restarting Power BI but I am still seeing the error. I have also confirmed using the SKY API console that I can access data with my API key.

Please can you advise?

Thanks,

Alex

Bonnie West

@Alex Feuchtwanger I just set one up as well and received the same error. Hoping someone will post a solution.

Alex Feuchtwanger

Hi @Bonnie West, mine seems to be working now and I'm not entirely sure why! When I went to

I had a request for data access permissions from the Power BI Connector app which I granted.

Then in Power BI I added a new data source using the ‘Blackbaud (beta)’ connector and it's worked. Maybe that's actually a new official connector? I've just got back from Xmas and honestly can't remember what my custom connector was called ?

Anyway, hope you also get it working, one way or another!

Rebekah Singleton

Hi @Bonnie West, were you able to resolve this issue? I've just connected everything, I ensured my app was set up to request full data access and then allowed that access through my BB app management as Alex linked previously. I'm still getting the error – “Access to the resource is forbidden”. Curious if you got this worked out.

Enrique Solis

@Rebekah Singleton Hi, I have the same issue. Have you found a solution?

Rebekah Singleton

@Enrique Solis Hey! I did get it fixed, although it wasn't a particularly linear solution. I ensured the app I set up was requesting full access, ensured that access was approved through the BB app management. I believe what fixed it was removing the app from RE NXT, I think I uninstalled PowerBI desktop, and then re-did the process from the point of adding the app in Marketplace, accepting permissions, etc. Then re-opened the data through PowerBI. It had my sign in to my Blackbaud account again which was what I was hoping to accomplish. Once I updated all of the access and re-signed in it all worked!

Liam Holmes

@Bonnie West
Bit late on this but ran into this issue myself.

The solution for me was to make sure the app had a valid scope, and then refresh the PowerBi auth.

To refresh the auth in PowerBi:
Open PowerBi Desktop
Under Home - Transform Data - Data Source Settings
Global Permissions - Select "Connect to your Blackbaud environment
Click Clear Permissions

Then you should be able to add the data source again and relog in.

Hope that helps!

Mark Lennon

@Liam Holmes
I got this to work after reading some of the posts here so thanks everybody as I was a bit stuck. Just a note to anyone else going through the same thing, after you change the scope on your app's data access (as a developer), you need to go back into the Marketplace and accept the changes (as the admin) to allow it to work. Then disconnect any previous attempts to connect from Power BI (Data Source Settings / Clear Permissions) and refresh the connection completely.

The instructions for setting up the app are good and very clear - but there are a couple of essential steps missing at the end it seems.

Greg Burton

@Mark Lennon
This is the step I was missing:

Then disconnect any previous attempts to connect from Power BI (Data Source Settings / Clear Permissions) and refresh the connection completely.

Thank you!