Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power Query vs Table View

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?

Need Help

2 Replies

  • Daniel29195's avatar
    Daniel29195
    Community Champion
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      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.