Extract records from a list to table

[MFasnacht]

Hi Everyone

I am loading data from the web through a REST API to Power BI Desktop

Now the data is loaded but shown as records in a list. When clicking on a record, it drills down and shows one entry in one row in a table. I can safe every record as a new query but not all in one step.
I want to have the data extracted from the records and to be shown in a table.

In the screenshots you can see how the data is shown as records and how the result should be. 

Could anyone help me fixing this?

Thank you for every answer. 

[v-sihou-msft · Accepted solution]

@MFasnacht

@Greg_Deckler is correct. You can directly do it on GUI.

Just click "To Table".

Then you just need to expand those columns.

Regards,

[Anonymous]

Hi, I had the same problem and this solution has worked and given me all the columns I wanted in a tabular format. However, all the columns have 'Column1.' appended to their original names. I have aboout 100 such columns and would really appreciate a quicker way of getting the original column names back. Thanks, Alisha

[MFasnacht]

Worked very well, thank you very much! 

[HennSarv]

Works well but ony with uniform records

I have list of records like

{ [Name="Henn", Age = 64], [Name="Peeter", ShueSize=27] }

how to convert into table

({Name, Age, ShueSize}, {{"Henn", 64, null}, {"Ants", null, 27}})

[Greg_Deckler]

I believe what you want is Table.FromList:

https://msdn.microsoft.com/en-us/library/mt260762.aspx