Recently I had to validate the row counts of some existing tables in PBI Data Flows that I was converting over to a new source. So wanted to make sure the row counts matched between the current and new source systems.
A simple way to do this is to add a blank query and use the Table.FromRecords and Table.RowCount functions:
let
Source = Table.FromRecords({
[Table = "Table 1 Original", RowCount = Table.RowCount(#"Table 1 Original")],
[Table = "Table 1 New", RowCount = Table.RowCount(#"Table 1 New")],
[Table = "Table 2 Original", RowCount = Table.RowCount(#"Table 2 Original")],
[Table = "Table 2 New", RowCount = Table.RowCount(#"Table 2 New")]
})
in
Source
