What strategies can help reduce query folding limitations in Power Query for complex data sources?
I'm facing issues with query folding when dealing with complex data sources in Power Query. Some of my data transformations aren't being pushed back to the source database, which is affecting performance. I'm looking for strategies to reduce query folding limitations and ensure that more of the transformations are executed at the data source for better performance.
What strategies can help reduce query folding limitations in Power Query for complex data sources?