Forum Discussion
cannot find the options preview features json table inference - Extract Tabular Data From JSON
Hi,
I want to find the below option.but in my power bi desktop it not shows.
What would be the issue .
File----> Options and Setings ---> options----> Preview Features ----> JSON table inference
please help.
Thanks,
Nuwan
3 Replies
- johncolleySolution Sage
HI nuwanhwb , It was a preview feature last year. It would be Generally Available now so you don't need to turn on any settings. Just use the JSON connector and it should work as needed.
- nuwanhwbFrequent Visitor
Hi Johncolley,
Thanks for your responce. i used that after installing the new desktop version.
But i need to read below JSON File structure and i need to expand bottom of the nested list.i used to read all the JSON files in a folder and expand to the end and transform.
Please comment
ThanksNuwan
johncolley wrote:HI nuwanhwb , It was a preview feature last year. It would be Generally Available now so you don't need to turn on any settings. Just use the JSON connector and it should work as needed.
- AnonymousNot applicable
Hi nuwanhwb ,
After you connect to the JSON file, you could trasform in the Power Query Editor. Here's an article you could refer to
Power BI JSON Connection: 3 Easy Methods - Learn | Hevo (hevodata.com)
Power Query JSON connector - Power Query | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.