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
9 years ago

I certainly will.

williamdasilva's avatar
williamdasilva
Regular Visitor
9 years ago

Anonymous Were you ever able to get PBI connected to SKY API? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    No, unfortunately I did not. I stepped away from it a while ago, though. With the API changing all the time, it'd be worth another look to see if it could be hacked together. If I do, I'll come back and update.

  • nancy1989's avatar
    nancy1989
    Regular Visitor
    8 years ago

    I don't have the perfect solution for this discussion but for the REST API, I have found an Excellent tutorial where you can learn how to use a REST API as a data source. It includes JSON Source Connector, XML Source Connector, and REST API Task.
    Check it out, https://zappysys.com/blog/howto-import-json-rest-api-power-bi/

     

    Hope it Helps!