Forum Discussion
Solved
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 e...
Greg_Deckler is correct. You can directly do it on GUI.
Just click "To Table".
Then you just need to expand those columns.
Regards,
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.