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

Options
Sam Chia
Sam Chia
Name Dropper First Anniversary Facilitator 1
in SKY Developer General Discussions

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

Tagged:

Comments

  • Christine Robertson
    Christine Robertson
    Kudos 5 Name Dropper Participant First Anniversary

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

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @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
    Sam Chia
    Name Dropper First Anniversary Facilitator 1

    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
    Sam Chia
    Name Dropper First Anniversary Facilitator 1

    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
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

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

    • the developer application access Scopes
    4f54180ae856385e4937777388c9d698-huge-im
    1b9672b5beeae55482771846eea27c53-huge-im
    • 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
    Sam Chia
    Name Dropper First Anniversary Facilitator 1

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

Categories