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.
Hi DALI007
Please refer to this link: https://learn.microsoft.com/en-us/power-query/filter-row-position
This might help you. Please let me know if you have any further questions.
Hi DALI007
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks
Hello Anonymous,
Thank you for your feedback. Unfortunately, the problem persists. I would like to know if it is possible to configure the DataFlowGen2 to retrieve only a limited number of data from all sources. Or, I wanted to know if it is possible to apply a specific setting to certain users only.
Thank youYou 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
