Forum Discussion
Extract records from a list to table
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.
Greg_Deckler is correct. You can directly do it on GUI.
Just click "To Table".
Then you just need to expand those columns.
Regards,
6 Replies
- Greg_Deckler
Community Champion
v-sihou-msftMicrosoft Employee
Greg_Deckler is correct. You can directly do it on GUI.
Just click "To Table".
Then you just need to expand those columns.
Regards,
Worked very well, thank you very much!
HennSarvHelper I
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}})
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
Old one, but it may help somebody:
At the Applied steps, right click on the Expanded Column1..., and delete "Column1" from here.
