JSON data source

[sachindekate352]

Standard JSON data, either from a file or web url

[ctrl_alt_d]

nice! Will be also available for web?

[WouterDriessen]

Can't wait to use it> In which update will this feature be released?

[brock]

but HOW do I "connect to JSON throught the Power BI Desktop". Is this referring to the "From Web" data connection?

[teva_delar]

I have tried to get in touch with Microsoft team regarding this implementation. It seems to be a real hassle to implement this. We, as a company, are investing a lot of time in trial and errors in order to have the full scope of the JSON capability, the documentation on this is really really really really poor !

[rogersherman]

Does anyone actually have this working? I've tried but the JSON file I'm supplying has a hierarchy and Power BI doesn't seem to go beyond the very first level. Which, for my file, is just a wrapper of all the meaningful data. Are others experiencing this issue?

[andrewt1]

This topic is marked COMPLETED, but there aren't any implementation details. How are we meant to retrieve JSON documents from a web URL in Power BI?

[mlyandersen]

Yes please do Thise feature

[nico10]

Hi Guys, newbie on Power BI, I tried to get BI and JSON to work today and after the first one I was very impressed with the capability, after I added my second JSON via WEB URL, I decided to refresh and the first JSON link died? Is this because the JSON download filename changes after every refresh?

[emilhassing]

What is the Status of this ticket ?

[ctembe_bi]

Hi... I am trying to pull JSON from Web. This is OKAY with JSON size of around 1000 records, but when Records are say around 50000+, it throws an Exception: "DataFormat.Error: We found extra characters at the end of JSON input" Need solution for the same. Please do help.