Updated on

Table.ToRows is a Power Query M function that creates a list of nested lists from a table, where each list item is an inner list that contains the row values. The function returns a list of lists representing the rows and their respective values.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


Table.ToRows( table as table ) as list


Table.ToRows creates a list of nested lists of row values from a table. Each list item is an inner list containing the row values from table.


Create a list of the row values from the table.

    Table.FromRecords( {
        [CustomerID = 1, Name = "Bob", Phone = "123-4567"],
        [CustomerID = 2, Name = "Jim", Phone = "987-6543"],
        [CustomerID = 3, Name = "Paul", Phone = "543-7890"]
    } )

 /* Output: 
    {1, "Bob", "123-4567"},
    {2, "Jim", "987-6543"},
    {3, "Paul", "543-7890"}

Other functions related to Table.ToRows are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: