i would like to know how to do this. i created sky api but wont authenticate oauth. i have been digging for solutions for over a year. please help.
Hi Karen,
I can understand your frustrations.
I have an “easy button” for you! You can find Charity Automator on the BB marketplace (link below). With Charity Automator, you can easily connect Power BI to an SQL database that is kept in Sync with your RE NXT (and FE NXT and Luminate Online).
https://app.blackbaud.com/marketplace/applications/8075c905-eacb-49cf-9843-d65982ae9bd0?envid=p-NJOUk1eRo0ex-DWjAz9CGg
You can reach out to me directly for more information.
Thanks,
William
Karen, have you watched Linton Myers' video showing how to set up the connector? I think he does a good job of making it clear and easy to follow.
Ho Ben. Agreed, the video is great. But I wish he went a little further. For ex, can you create a list in NXT and access it in PowerBi? I haven't been able to figure this out. Is there a video that picks up where he left off? Now that you made the connection, how do you use it? Thanks! Eileen
Is there a Power BI for Sky Blackbaud Grantmaking?
@Eileen Wallwork, yes, you can access public and private RENXT Constituent and Gift lists within Power BI.
Once you have the connection set up, you can go to Get Data > Other > Search for “Blackbaud” and connect.
Once that connection is made, you'll see all the endpoints you have access to. Under the “Constituents” folder are folders for public and private lists. Same thing in the Gifts folder.
It's true that just getting the data into Power BI is only the first of many steps needed to make a useful report, and I've often found that a key piece of data I need for my report is buried within an object within a column, so you may have to do some data manipulation and transformation before you can use it the way you want to in your reports.
As with many things these days, YouTube can be a pretty valuable resource. The Guy in a Cube channel has useful videos for getting started, and once you know more about what you need to learn, you can find many other useful channels as well.