Forum Discussion
matheusmelillo
1 year agoNew Member
Transform A List of Records into a Table
Hello, Im kinda new to API sources in PowerBi and I'm sutck in the following situation: I get from a API a JsonDocument with list of records with many lines: Each of this records loo...
- 1 year ago
Have you tried Table.FromRecords?
With a 'Source' similar toTable.FromRecords(Source)gets you...
If you only want specific fields from the records you can add a step after the source.
As an example choosing the first and third columns would end up with this example code...
let Source = { [First="value from row 1 column 1", Second="value from row 1 column 2", Third="value from row 1 column 3", Forth="value from row 1 column 4"], [First="value from row 2 column 1", Second="value from row 2 column 2", Third="value from row 2 column 3", Forth="value from row 2 column 4"], [First="value from row 3 column 1", Second="value from row 3 column 2", Third="value from row 3 column 3", Forth="value from row 3 column 4"], [First="value from row 4 column 1", Second="value from row 4 column 2", Third="value from row 4 column 3", Forth="value from row 4 column 4"] }, select_fields = List.Transform(Source, each Record.SelectFields(_, {"First", "Third"})), convert_to_table = Table.FromRecords(select_fields) in convert_to_tableend a result of...
- 1 year ago
=Table.FromRecords(yourRecordList,Record.FieldNames(yourRecordList{0}),2)
Anonymous
1 year agoNot applicable
Hi matheusmelillo,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.