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 miguel ,
The article you gave me talks about power query. and more precisely it talks about a parametrage to make level of each table. I wanted to know if there is a possibility to limit the number of fetch lines at the PowerBI Service source connection please.
Thank you for your help
Power Query is the tool used by Dataflows and Power BI to get the data. The article showcases how you can leverage Power Query to implement your own filters and limits when connecting to a source.
Something like "Top 1000 rows" would yield the top 1000 rows of the result of your query. It also depends if your query can fully fold, but conceptually that's the sort of logic that you can implement at each query in your Dataflow, Power Query or Power BI Semantic Model.