Forum Discussion
SQL Server Management Studio like row count for each var in Power Query
Hi smpa01 ,
When you click on a step in Query Editor in Power BI, on bottom left you see number of columns and number of rows on that step.
Is this what you are looking for?
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
yes, I am looking for something like this. But you currently have 20 rows which is why it gives you an excact count. I am working with 40k+ rows, it shows the following
Hi smpa01 ,
Yes I also checked it on another dashboard where I have a million rows. It just shows columns, not rows.
I found a similar thread where there is a workaround on achieving this:
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
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.
