Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Using a REST API as a data source

I'd like to be able to connect to a Blackbaud REST API to pull data from that system and use it in a Power BI Desktop report: http://on-api.developer.blackbaud.com/getting-started/   That said, I d...
Need Help
Tutorial Requests
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I've very interested. I'll send you a DM.

williamdasilva's avatar
williamdasilva
Regular Visitor
8 years ago

Wonderful! We are actually looking for organizations to be part of an early adopter program.

I will wait for your DM.