Forum Discussion
cannot find the options preview features json table inference - Extract Tabular Data From JSON
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.
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
Thanks
Nuwan
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.
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.