Power BI and Blackbaud Financial Edge NXT via SKY API Console

marc cannon

We're trying to get our NXT data loaded onto Microsoft's Power BI so we can built some internal financial dashboards.


So far we've been able to build out an app, but we need help getting everything configured. We're currently stuck on building out our ODBC data source. We downloaded a driver from CData on a 30 day trial, but we're hoping that Blackbaud has one available that we won't have to pay for (we're a non-profit, so we try to save money wherever we can).


Within the SKY app, we need to know what to input for our redirect URI. This is the tutorial we've been following so far (https://www.cdata.com/kb/tech/blackbaudfenxt-powerbi-gateway.rst), but this is from CData themselves. So I suspect there might be a better, cleaner way to get our API configured that we just don't know about. Open to other solutions.

Daniel Leonard

Hi Marc,


Thank you for the questions.


Unfortunately, I am not aware of us offering an ODBC driver but it is something we can investigate for future requests.


Here is a link to our UI Extensibility tutorials that might help. https://developer.blackbaud.com/skyapi/docs/addins/get-started


In regard to the SKY App redirect URI, are you using the SKYUX framework to create your application? If so, during development, when you launch the application locally `skyux serve -l local`. The application will normally launch on `https://localhost:8000`. You will need to add a Redirect URI pointing to the entry point of your application. An example would be `https://localhost:8000/mytile` for local development, where the `mytile` folder has an index.html page as an entry point.


If you are not using the SKYUX framework, you will want to add the redirect URI pointing to your local application entry point during development.


Once the application is deployed to production you will need to add a RedirectUri pointing to the deployed production entry point for your application.


Please let us know if you have more questions.