Forum Discussion
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 JSON files as data sources, but the query (posted as a URL) returns JSON on a page. Is there anyway to get Power BI to read that output and use it as a data source? Throwing the query URL in as a web data source produces nothing.
A Semantic MediaWiki Ask API data source type would be perfect, but it looks like no such thing exists.
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:
Regards
6 Replies
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:
Regards
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.
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.
