Table.SingleRow is a Power Query M function that returns the single row in a one-row table. The function throws an exception if the table has more than one row.

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


Table.SingleRow( table as table ) as record


Returns the single row in the one row table. If the table has more than one row, an exception is thrown.


Return the single row in the table.

// Output: [CustomerID = 1, Name = "Bob", Phone = "123-4567"]
Table.SingleRow( Table.FromRecords( {[CustomerID = 1, Name = "Bob", Phone = "123-4567"]} ) )

Other functions related to Table.SingleRow are:

BI Gorilla Youtube Channel

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation:
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.