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
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

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?

WolfBiber

Microsoft Employee

8 years ago

yes, as long certain metadata of the fields doesn't change.

But be aware that autorefresh datasets with parameterized web source isn't supported in PBI Service.

But there are several work around that you can find i.e. here

Greetings

SFNative
Frequent Visitor
8 years ago
Thanks, WolfBiber. I'll check that out.

Forum Discussion

Semantic MediaWiki Ask API

Related content

Semantic Model

Healthcare Semantic Model

Semantic Models

Does getDefinition support DirectLake semantic models?

One Semantic model VS Multiple Semantic Models