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  

ArgumentDescription
recordsThe List to convert.
optional columnsAn 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"]})  

CustomerIDNamePhone
1Bob123-4567
2Jim987-6543
3Paul543-7890
Show: