Power Query editor

%3CLINGO-SUB%20id%3D%22lingo-sub-3072845%22%20slang%3D%22en-US%22%3EPower%20Query%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3072845%22%20slang%3D%22en-US%22%3EIt%20would%20be%20very%20useful%20to%20have%20a%20row%20count%20at%20the%20bottom%20of%20the%20power%20query%20editor%2C%20similar%20to%20power%20bi.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20that%20possible%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3072845%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3073100%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3073100%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1287774%22%20target%3D%22_blank%22%3E%40Lanxama3018%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20exactly%20do%20you%20mean%20%3F%3C%2FP%3E%0A%3CP%3EExcel%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20581px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F342748i5B6EDD1E734FA593%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EPower%20BI%20Desktop%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20611px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F342749i9075044ED3DD8C55%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3073237%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3073237%22%20slang%3D%22en-US%22%3ESorry%20I%20should%20have%20been%20more%20specific%2C%20in%20power%20query%2C%20in%20the%20data%20view%2C%20it%20shows%20the%20exact%20number%20of%20rows%20in%20the%20datatable.%3CBR%20%2F%3EIt%20would%20be%20handy%20to%20see%20the%20exact%20row%20count%20in%20the%20query%20editor%20view.%3C%2FLINGO-BODY%3E
New Contributor
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
7 Replies

@Lanxama3018 

What exactly do you mean ?

Excel:

image.png

Power BI Desktop:

image.png

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.

@Lanxama3018 

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
Oliver

@Lanxama3018 

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.

image.png

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

@Lanxama3018 

So, we speak about Power Query editor, not about difference between Excel and Power BI Desktop. If Power Query doesn't load result to data model (e.g. connection only mode) in both we have only Power Query editor to check. If we load to data model, in both we may work further with data model, the only entry points are different.

 

For both in Power Query editor we may see number of values in the column if shift column profiling base from first 1000 rows on entire data set rows and keep active Column Profile in View tab. That is actually number of rows.

image.png 

 

If by default evaluate preview based on entire data set performance could be decreased dramatically. Both for Power BI Desktop and Excel, doesn't matter.