! [Expression.Error] The field 'access_token' of the record wasn't found.

Sam Chia

Hi folks,

I have created a Power BI connector following Linton Myers' Youtube video guide and I have documented the detailed steps and sent to Blackbaud support and they have verified that I have followed the steps correctly.

However, when I was trying to "Get Data" to this connector in Power BI and after signing in and clicking on the [Authorize] button, it throws the follow error...

! [Expression.Error] The field 'access_token' of the record wasn't found.

I reached out to Blackbaud support regarding this error and despite they having me gone through a successful 'Constituent (Get)' test with my SKYAPI subscription key at API reference > Raiser's Edge NXT > Constituent > Endpoint reference, I was still encountering the error. They confirmed that my account has a valid subscription and access keys but says that it might be an authentication issue which they can't confirm. They could not assist further and point me to seek help from this community.

Does anyone has a clue on how to resolve this connection issue?

Thanks & regards,
Sam Chia
schia@wwf.sg

Christine Robertson

@Alex Wong - Is this something you can help with?

Alex Wong

@Sam Chia
Without knowing what you did or didn't do to set this up, it's hard to say what went wrong.

Please check this post on my replies regarding the steps needed to be done and confirm if you have to all the same first.

Sam Chia

Hi @Alex Wong,

Thanks for assisting and sharing your guide.

Give me sometime to look into your steps and see what I might have missed and then I will come back to you. But in the meantime I have attached the detailed steps of how I created the connector, for your understand.

Readme.txt

Thanks & regards, Sam

Sam Chia

Hi @Alex Wong, I managed to make a connection to Blackbaud with my tweaked Power BI connector, but when trying load the tables all of them says "Expression.Error: Access to the resource is forbidden.". What/where else might I need to fix? Expression.Error - Access to the resource is forbidden.png

Alex Wong

@Sam Chia
here's the big items to make sure:

• the developer application access Scopes

• You added https://oauth.powerbi.com/views/oauthredirect.html as a Redirect URI in your developer application.
• Connect the MS Power Platform app: https://app.blackbaud.com/marketplace/applications/848afa1d-fe4a-4331-8e03-79ea0d000343
• You downloaded from: https://github.com/blackbaud/powerbi-connector
• You created the Blackbaud.mez (exactly this file name and mez extension) in the folder mentioned in previous post. Also the Blackbaud.mez file has all the files in it and if you were to open this file in a zip profile (like 7-Zip), you can see all the files directly without folder in the zip file (There were others before who zip the files with a folder, and that caused problem)

• ensure you updated the client_id.txt, client_secret.txt and subscription_key.txt with your developer applicatoin's Application ID, Primary (or Secondary) Application Secret, and your developer account subscription primary (or secondary) access key.
• Ensure your Power BI Desktop setting allows for custom connector

Sam Chia

@Alex Wong, I have sorted out the access scope and tables are loading fine now. Thanks for useful advises!