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.
- nuwanhwb4 years agoFrequent 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.
- Anonymous4 years agoNot 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.