Table.FromRecords
This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.
Returns a table from a list of records.
Table.FromRecords(records as list, optional columns as any) as table
| Argument | Description |
|---|---|
| records | The List to convert. |
| optional columns | An optional list of column names, or a table type could be provided as the second argument, which much match names found in the records. Record fields which don’t appear in the list are ignored. |
Table.FromRecords({
[CustomerID = 1, Name = "Bob", Phone = "123-4567"],
[CustomerID = 2, Name = "Jim", Phone = "987-6543"],
[CustomerID = 3, Name = "Paul", Phone = "543-7890"]})
| CustomerID | Name | Phone |
|---|---|---|
| 1 | Bob | 123-4567 |
| 2 | Jim | 987-6543 |
| 3 | Paul | 543-7890 |
Show: