Extract Json into table

[Markzolotoy]

I am loading pretty complex json which is a sort of master/detail data. After executing the query I see this:

I can create a new query for each record, but the data is already been received, so can I just create new tables with these details without pulling it from the server again and again?

Thanks

[Markzolotoy]

@PhilipTreacy What I mean by creating new tables is that there is no need to pull data for each of it. All the data come down at once. Even if I create new tables from that data it looks like each table will have to get its own portion of data fro the server. Am I wrong?

[PhilipTreacy]

Hi @Markzolotoy 

Each time you refresh the query/data all the data is pulled again.  That's the way PQ is designed to work.

regards

Phil

[PhilipTreacy · Accepted solution]

Hi @Markzolotoy 

From the Ribbon, on the Convert tab you should have the option to Convert to Table

Giving this

Filter out the top row

Now you can expand the Records all at once. or filter the Name column for just the ones you want.

I'm not sure what you mean by can I just create new tables with these details without pulling it from the server again and again?  

The way PQ/PBI works is that query resfreshes will go and get the latest data from the server.  

Regards

Phil