Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SFNative
Frequent Visitor

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.

1 ACCEPTED SOLUTION
v-ljerr-msft
Employee
Employee

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? Smiley Happy

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

https://social.technet.microsoft.com/wiki/contents/articles/37512.create-power-bi-reports-from-json-...

 

Regards

View solution in original post

6 REPLIES 6
v-ljerr-msft
Employee
Employee

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? Smiley Happy

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

https://social.technet.microsoft.com/wiki/contents/articles/37512.create-power-bi-reports-from-json-...

 

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.

 

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?

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

Thanks, @WolfBiber. I'll check that out.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.