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
Hello miguel,
Thank you for your feedback. If I understood correctly, you mentioned the use of Power Query on a specific table in your message. However, I would like to know if it is possible to apply this setting automatically to all tables within Data Flow Gen2. In other words, I want this parameter to be applied automatically to each recovery table in Data Flow Gen2.
So I wanted to know, how to make this setting can be applied to all Data Flow Gen2 of the same workspace.
Thank you very much
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.