Forum Discussion

hoosha_11's avatar
hoosha_11
Helper I
2 years ago

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

  • what's your data source? Consider using Value.NativeQuery and indicate that folding should be used.