cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nuwanhwb
Frequent Visitor

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 3
johncolley
Super User
Super User

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.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors