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.
Hello Anonymous ,
Thank you for your quick feedback
thank you for your quick feedback
After 7hour data recovery I got an error message. can you tellme what parametrage to do to make a line number limit please ?
Thank you
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.
ThanksHello 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