//VAR DBG_ROWS_LIMIT = 20 does not change number of rows in the debugger

didierterrien / Power-BI-Sidetools

Power BI Sidetools is a free Power BI external tool intended to increase productivity during reports development in Power BI desktop.

69 stars 7 forks source link

//VAR DBG_ROWS_LIMIT = 20 does not change number of rows in the debugger #22

Closed hcc-donder closed 3 years ago

hcc-donder commented 3 years ago

When I specify //VAR DBG_ROWS_LIMIT = 20, I still get 30 rows in the debugger. I am using version 1.2.2 with the May 2021 (version 2.93.981.0 64-bit) version of Power BI Desktop.

didierterrien commented 3 years ago

Did you write debug instructions after a RETURN expression ?

hcc-donder commented 3 years ago

No. I have it like this:

Measure name = 
VAR variable1 = DISTINCTCOUNT( TableName[ColumnName] )
//VAR DBG_ROWS_LIMIT = 20
RETURN
    variable1

This still shows 30 rows.

didierterrien commented 3 years ago

I cannot reproduce the issue. I just tried with Contoso copying and pasting your measure (image below). I published version 1.2.3 today. Can you update and retry please ? If it's still not working, can you share a simple pbix ? You might also try to copy and paste the measure from above into the desktop in order to avoid any invisible character.

hcc-donder commented 3 years ago

I installed the new version and it works correctly with the new version. Thank you.

didierterrien commented 3 years ago

Thank you for your contribution !