Fabric Power Query Row Count

[exb]

As with Power BI Desktop I find it very useful in validating my data as "flow" to see the actual row count at the bottom left of the screen, rather than just 99+. CoPilot tells me this is not possible, but to instead create a Table.Profile step after each transformation. I do not find this to be an efficient way of quickly making informed assumptions about my data flow as I'm designing it. 

[miguel]

Power BI Desktop and Power Query in Excel follow the same principles that Power Query Online inside of Dataflow Gen2 does. We try to leverage lazy evaluation as much as possible, which means that we only compute things when they're absolutely necessary in an effort to prevent overloading your data source and/or your own resources in your desktop environment or the cloud.

This means that if you're working with a table that has billions of records and you perform some transformations that could be deemed expensive by your data source, that we will only request to compute around 200 rows of data for the data preview that we showcase, but the rest will not need to be computed and an exact number of rows that could be yielded by that specific step is not required in an effort to not overload the source.

You can, however, click on the "Transform" tab and click the option to "Count rows" which will give you the value that you're after inside of the Data preview