Forum Discussion
hoosha_11
2 years agoHelper I
Table.Distinct and Table.Group breaks query folding
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!
1 Reply
- lbendlinSuper User
what's your data source? Consider using Value.NativeQuery and indicate that folding should be used.