Forum Discussion
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 subqyery is generating duplicate rows on a join. If I do 50 steps in pqwry and on each step I can see the row counts, I can easily debug my query on that step rather than having to find out the bug after writing 50 lines.
I don't know if there is a way to currently do it or else I want to float this idea.
Thank you in advance.
6 Replies
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
Hi smpa01 ,
You could vote for this similar idea to improve Power BI and make this feature coming sooner. As a limit, 999 is too few.
