Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi,
I'm using Table.distinct to remove duplicates from a column in a table but query folding breaks, even if I remove duplicates in the last step. The transformation process is quite simple, with only four steps. Even using Table.Group and "Count Distinct Rows" =1 breaks the fold.
Any idea how I can maintain query folding after removing duplicates from a column?
Thanks!
what's your data source? Consider using Value.NativeQuery and indicate that folding should be used.
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 2 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 15 | |
| 6 | |
| 6 | |
| 5 | |
| 5 |