Forum Discussion

smpa01's avatar
smpa01
Community Champion
6 years ago

SQL Server Management Studio like row count for each var in Power Query

Hi,   Is it possible to see the row counts for each steps/variables in Power query like SSMS shows for each query/subquery.   If I can see the row count in PQWRY I can easily determine if my ...
Need Help
smpa01's avatar
smpa01
Community Champion
6 years ago

Pragati11 thanks for this, but I do not want to write another query to count the rows. PQWRY has severe performance issues on large tables and I can't imagine running a parrallel query just to catch the row count on each step. Getting row count is great for debugging and if MS can incorporate the excat count (if there is no other way we know of) that in pqwry would be great.

 

Also, running the column profile has severe performancer issues on overall query and I am speaking that from my experience.

 

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi smpa01 ,

     

    I understand the performance issues on larger tables in Power BI as I myself work on large datasets in Power BI on daily-basis.

    Looks like there isn't a way of achieveing this currently in Query editor in Power BI.

     

    Thanks,

    Pragati