Forum Discussion
Using a REST API as a data source
Anonymous
I don't know the Blackbaud REST API in your case and it is not in the list of suppported "Online Service".
But according to the content in the link that the API reponses in JSON, you can get the data by using "Get Data"-->"Other"-->"Web". And then extend JSON to a table in query editor.
eg. http://jsonplaceholder.typicode.com/posts/1/comments
You can replace it with a link like "http://[school].myschoolapp.com/api/academics/department/?t=[token returned from previous step]" in your link.
In the query editor,
Done
Regarding refreshing, you can publish it to Power BI Service and schedule refresh.
Hello Casey,
Were you able to successfully link Power BI to one of Blackbauds applications? My organization uses Financial Edge and have been tinkering with Power BI. Currently we are just dumping data into excel sheets and loading them into Power BI.
Thanks,
Anonymous, no luck connecting through Power BI yet.
I was able to get access to the SKY API beta and have played around with test calls with their developer tools. It looks very promising and exicting.
Though things are working inside the test sandbox on the SKY developer website, I haven't yet gotten a connection to work within Power BI Desktop. I suspect I'm just not authenticating correctly, but I have tried all sorts of credential combinations with no luck yet. I'll keep poking at it, and hopefully enlist a developer friend of mine for advice, and will post back when/if I figure out the magic formula.
If/when you are succesful at connecting to Blackbaud REST API - I would be very interested in the settings needed. I can't seem to get the authorization to work and have been told by Blackbaud that this is not available yet.
I certainly will.
Anonymous Were you ever able to get PBI connected to SKY API?
