Power Query vs Table View

[Anonymous]

In Power Query, a simple SQL Server query is defined.  It produces 10,010 records.  

When viewing this table, it only goes up to 1,518

Why is it limiting the data?

[Daniel29195]

@Anonymous 

this is weird !

if you drag the index column to a visual, and select to show the max,  

will it also give you ,  1518 ? 

[Anonymous]

So I rewrote what was going on in the Power Query transform steps into the SQL instead, to perform the steps on the database.  It resulting in the 1518 groups.  With that, I'm assuming it is coming out of Power Query and into the table view and visuals correctly now.  The only bug then would be the data view in Power Query not showing correctly.  The only steps were a Grouping, then a Record count, with a couple of filters based on avoiding nulls and limiting the count > 1.