Forum Discussion
Power Query editor
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
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.
It would be handy to see the exact row count in the query editor view.
Screenshots above are from Power Query editor.
- 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.
Thanks
OliverOliver, 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.
- Thanks Sergei,
That’s my point, it would be very handy to have this view of the exact amount of rows in the editor pane, so you can assess the roe count whilst editing and not have to go to the pivot after. For instance when I merge a large dataset with another, and I have a rough idea what the row count should be, it would be immediately obvious (if I could see the exact row count) if the merge had caused any rows to duplicate.
Thanks Oli