Establishing connection between Power BI and RE NXT

Rosa Crichton · April 18

I am trying to establish connection between PBI and RE NXT. We recently converted to RE NXT. Blackbaud was not listed in "Other" from “Get Data” in PBI. Am I missing a step? Help is greatly appricated.

*These are the old posts I was following with no luck.-->

https://github.com/GrantQuick/BlackbaudSkyApi-RENXT

https://github.com/blackbaud/powerbi-connector?tab=readme-ov-file

Alex Wong · April 19

@Rosa Crichton
did you follow the instructions?

here's a post where i replied with instructions that has screenshots that helps guide you, but same instruction.

https://community.blackbaud.com/forums/viewtopic/426/64701

Rosa Crichton · April 21

@Alex Wong
Thank you for your help.

Yes. I followed the guide. The mez file was stored in external G drive. Now I re-added the mez file in the computer local c drive with no luck still. Blackbaud did not poplulate in Get file of PBI.

Alex Wong · April 22

@Rosa Crichton
not sure where “get file” you are looking.

in Power BI, you click on Get data, and then select More…

40c236aae8edf81ac630509c6a1ccb15-huge-im

Then you select Other and will see Blackbaud (Beta) (Custom)

98264fbb23dfd1fbbaa01d2edf48395b-huge-im

This is assuming you did all the steps correctly. If you do not see Blackbaud (Beta) (Custom), then please send some screenshots of:

the mez file and its location, to verify that you renamed the zip file correctly as real mez file, not Blackbaud.mez.zip
developer.blackbaud.com's Application scope, environment, and redirect section, the application that you entered the client_id and client_secret into the mez file

Rosa Crichton · April 22

@Alex Wong
Hi, here are the screenshots.

Get data-→Other

9bc8b88bec13b672aba7ef1de1ca6370-huge-sc

URI and Scope

b17dc17b58c8d4aab0999a42aec56970-huge-ap

Enviornment

f65caf6b3d619277ec1ec681c16af2f1-huge-en

Blackbaud.mez files

f0b370315528d16afca8eaae4747d346-huge-me

Rosa Crichton · April 22

@Alex Wong
Update: I was able to get data to show blackbaud. but now we are coming arcoss this error. please see screenshot.

d0c2c0ed31b54cf3aec1e60becb08404-huge-sc

Alex Wong · April 23

@Rosa Crichton
in your previous screenshot, for Environment, you see that your application is not Authorized.

You will need to authorize it for use, I normally would just remove the the app from marketplace and add it again.

Rosa Crichton · April 23

@Alex Wong
Thank you. I removed the app and re-add it. Got the same result. no authorization.

I was able to establish connection with my consultant. He cutted and pasted his mez file then changed his app id, client id, and client secret to mine.

We still do not know what the root cause is. Maybe something to the zip file I downloaded from the Github a few weeks ago.

Alex Wong · April 24

@Rosa Crichton
I remember there was something specific to deal with the “authorization=false” issue on your application. @Erik Leaver helped someone so maybe he can assist here too

Erik Leaver · April 24

@Rosa Crichton Just so I'm clear, do you have a working connection using the file your consultant provided or is there still an authorization issue?

Tina Metzger · April 24

@Rosa Crichton We are having a hard time finding the Client ID and the Client Secret from the application we registered from the getting started section. We are also trying to set up a team so our developers can see the applications and help work on them.

Rosa Crichton · April 24

@Tina Metzger
Assuming you have Sky API account created, the application you created is in the Developer Account tab. Here is a screenshot.

Application: Client ID and Client Secret

c6fe03a5eab70641cd4743f6fdd29cdf-huge-ap

Rosa Crichton · April 24

@Erik Leaver
Yes, I have connection to Blackbaud tables. I just just checked my enviornment and there is now a yes in my authorized column. Weird.

Erik Leaver · April 24

@Rosa Crichton Alex alluded to some of the odd behavior with the authorizations. Sometimes they require a restart. But awesome you can see this!

Establishing connection between Power BI and RE NXT

Comments

Categories