Forum Discussion

SFNative's avatar
SFNative
Frequent Visitor
8 years ago
Solved

Semantic MediaWiki Ask API

Im trying to make use of data found in a MediaWiki powered page. The API allows for pages to be queried but the only (recommended) output option is JSON (not remotely my strength). I know we can use ...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi SFNative,

 

With the Web connector, you should be able to get the content in the link that the API responses in JSON, and then extend JSON to a table in query editor. 

 

In addition, followings are some good article about how to use Power BI to call REST APIs and parse JSON. Could you go to check if it helps in your scenario? :smileyhappy:

https://blogs.msdn.microsoft.com/charles_sterling/2016/05/25/how-to-call-rest-apis-and-parse-json-with-power-bi/

https://social.technet.microsoft.com/wiki/contents/articles/37512.create-power-bi-reports-from-json-data-exposed-by-rest-service.aspx

 

Regards

  • SFNative's avatar
    SFNative
    Frequent Visitor
    8 years ago

    Thanks v-ljerr-msft. That worked.

     

    One question, though. Do I need to go through the steps to extend the JSON to a table whenever the data that would be returned in the JSON changes? I'm assuming so, but I wanted to double-check.

    • WolfBiber's avatar
      WolfBiber
      Microsoft Employee
      8 years ago

      What Data changes? the data itself inside JSON or the metadata (definition of fields?).

      That the data changes is very, very common, because new data entries will be applied.

      If the metadata changes everything should work also, as far the fields for transformations in later steps keep unchanged.

       

      • SFNative's avatar
        SFNative
        Frequent Visitor
        8 years ago

        It's the data in the JSON that changes.

         

        So, to be clear, when the data on the site changes, the data in the JSON pulled as a data source would change with a refresh in Power BI?