Power Query editor

Question

It would be very useful to have a row count at the bottom of the power query editor, similar to power bi.Is that possible?Thanks

sergeibaklan · Answer

Lanxama3018&nbsp;
What exactly do you mean ?
Excel:

Power BI Desktop:

lanxama3018 · Answer

Sorry I should have been more specific, in power query, in the data view, it shows the exact number of rows in the datatable.It would be handy to see the exact row count in the query editor view.

sergeibaklan · Answer

Lanxama3018&nbsp;
Screenshots above are from Power Query editor.

lanxama3018 · Answer

Thanks Sergei,Yes agreed, but it says 999+ rows when over a thousand. However in power bi data view, at the bottom of the screen it states the exact amount of rows in the dataset.It would be good to have this in power query editor, instead of the 999+, as I’m building a large dataset by merging.ThanksOliver

sergeibaklan · Answer

Lanxama3018&nbsp;
Oliver, Power BI Desktop Data view is actually shows you data model table. That's not Power Query. If in Excel you open data model with Power Pivot it also shows full number of records.

Forum Discussion

Power Query editor

7 Replies

Resources