Keep unique rows stopped working

[henripe]

If you have for example two employees with same name, keep unique rows set to "True" is not working anymore and two employees are shown as one. Please fix this as soons possible

[v-tianyich-msft]

Hi @henripe ,

Power BI removes duplicate rows from a table by default. This is due to Power BI being a aggragation tool.The way around this would be to create a index column to provide the uniqueness of rows.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

[henripe]

Yes, I do know that this is the behaviour by default. But when setting "Keep unique rows" as true, the behavior changes.

Please see the MS documention:

Keep Unique Rows

False

Specifies which columns provide values that should be treated as unique even if they are duplicates (for example, employee first name and last name, for cases where two or more employees share the same name).

https://learn.microsoft.com/en-us/analysis-services/tabular-models/column-properties-ssas-tabular?vi...

[v-tianyich-msft]

Hi @henripe

This setting doesn't seem to apply to Power bi desktop, which means that if you set it up in a data source such as AS or AAS, it won't take effect when you connect to Power bi desktop.

Best regards,
Community Support Team_ Scott Chang

[henripe]

Yes, and that's why this ticket was created. It did apply before. Started receiving messages from users last week.