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

[smpa01]

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.

[v-eachen-msft]

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.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/35731375-always-show-row-count-at...

[Pragati11]

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

[smpa01]

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

[Pragati11]

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:

https://community.powerbi.com/t5/Desktop/Row-count-at-each-step-in-Query-Power-BI-Desktop/td-p/19295...

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[smpa01]

@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]

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