Forum Discussion
saturation occurred at DataFlowGen2
Not a feature that exists today, but you can definitely suggest this as a new feature by posting your idea in the Fabric Ideas portal (https://aka.ms/FabricIdeas).
At the moment if you wish to set a particular limit or want to take advantage of query folding in any particular way, you will have to do it at the query level inside of the Power Query editor. Don't forget that it also depends on how things will get evaluated, so its important to understand what queries might benefit from such filter and what others might not get any sort of benefit from it due to how query folding wouldn't impact it or simply how query folding isn't supported for a particular data source.
You can set filters for your queries as needed and limit things that way.
These two articles might help you with how to filter data in Power Query:
Filter a table by row position - Power Query | Microsoft Learn
Filter by values in a column - Power Query | Microsoft Learn
You have full control over what data should be queried to your data source and, if the data source supports query folding, then that should limit what data is being requested to the data source as well.
You can read the article below to learn more about query evaluation and query folding in Power Query:
Understanding query evaluation and query folding in Power Query - Power Query | Microsoft Learn
