Dataflow Enhanced Engine is On. Why folding doesn't work?

Which option are you using in Power Bi desktop? I think I read that it will only fold if you use the newer Dataflows connector rather than the original PowerBI Dataflows connector.

Hi olegkazanskyi 

Dataflow Enhanced Engine and Query folding are not related .

Dataflow Enhanced Engine : Reduce refresh times for long-running ETLs and facilitates direct queries on entities .

Query folding : Query folding is the ability for a Power Query query to generate a single query statement to retrieve and transform source data.

As you said that you have a simple filter function in the dataset's query to extract the last 3 months data , but the amount of data pulled is as big as the full 5 years of transactions . Maybe you can set the filter in Desktop or data source to see if the returned data is filtered by you .

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.