Query folding disabled for dataflow?

[PowerBITestingG]

As of last week, all my reports that have a dataflow as a source cant seem to use query folding...

Anyone experiencing something similar?

[v-yanjiang-msft]

Hi @PowerBITestingG ,

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ kalyj

[v-yanjiang-msft]

Hi @PowerBITestingG ,

Is your problem still persists. Can you use it successfully before and just broken recently?

In order to use Query folding with dataflow, there're some precondition:

1. Enhanced Compute Engine is turned on.

2. Have a PPU or Premium lisence.

3. Use the Dataflows connector not Power BI dataflows connector.

Reference: How Query Folding And The New Power BI Dataflows Connector Can Help Dataset Refresh Performance 

Best Regards,
Community Support Team _ kalyj

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

[Migasuke]

Hey @PowerBITestingG ,

what is your source that you want to fold?

[PowerBITestingG]

A dataflow

[Migasuke]

Check in the settings of dataflow if you have enabled Enhanced Compute Engine:

https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-premium-features?tabs=...

[PowerBITestingG]

It is enabled, its very strange. The reports that havent been changed in more than a week are running fine and fast with incremental refresh.

But the reports that have been updated in the last few days seem to have lost that ability and are taking forever to upload. 

Do you think if I turn if off then on, it will break those old reports and they will have to realod the entire source again?

[Migasuke]

It is very likely, that the report would need to refresh the whole history.
Maybe try to create a copy of this Dataflow and recconect one of the report to see if the refresh will work.