search

blackbaud / powerbi-connector

Blackbaud data connectors for Power Query and Power BI
MIT License
24 stars 15 forks source link

Expression.Error: Access to the resource is forbidden. #19

Open juliannegibson opened 1 year ago

juliannegibson commented 1 year ago

I have followed the steps to set up the custom connector. I can get all the way past get data -> other -> blackbaud (beta) -> login. Then, when I get to the data navigator and I attempt to click on data, I get the "Expression.Error: Access to the resource is forbidden.". I have researched it in Microsoft forums and Stack Overflow and everyone says to delete the connector, restart Power BI, and reconnect it and it should work. It hasn't worked for me. Any insight or advice?

sundres commented 1 year ago

See this helpful thread on the Blackbaud Community: Power BI Connector: 'Expression.Error: Access to the resource is forbidden.'

The missing step is related to the App’s scope:

  1. After creating the Power BI app in the Sky Developer’s portal, open the app’s details page and edit the Scope to allow “Full data access.”
  2. Then go back into the Marketplace and accept the changes (as the admin) to allow it to work. Marketplace > Manage > Power BI Connector (your app) > Security, confirm that full data access is allowed.
  3. Open Power BI Desktop and walk through the Get Data steps.