Tables from Dataflows Gen1 with Enhanced Compute Engine turned on no longer fold to the

[PagnumBI]

I wanted to check if there's a wider issue for Enhanced Compute Engine Dataflow Gen 1? 

My recent expience:

I have a power bi desktop file loading some queries from a dataflow with this turned On and it was folding nicely earlier this week, but then since yesterday it no longer folds - and i can't see why. (FYI workspace is Premium Per User - Reserved, SKU: PP3, Region: UK South)

As a test I made a new dataflow (A), I've tested linked entites within A, tried setting up a second dataflow (B) that linked to the tables in A and then referenced the linked tables in that that also. Everything thing looks ship shape in the service, got the lightning symbols etc. But when i open a new PBIX file and load data from any of these and just apply a simple filter there is no folding  (I've check diagnostics and no SQL to be seen). 

Question: Is anyone else expiencing something similar? 

[PagnumBI · Accepted solution]

Thanks for you replies folks - I was biding my time since @rohit1991 mentioned other uses had noticed similar issues. It looks like it is working now! Guessing it was related to August desktop release but seems to be working properly now

[v-nmadadi-msft]

Hi @PagnumBI 
We really appreciate your efforts and for letting us know the update on the issue.

Please continue using fabric community forum for your further assistance.
Thank you

[v-nmadadi-msft]

Hi @PagnumBI  ,
Thanks for reaching out to the Microsoft fabric community forum.

If you are using direct query with dataflow in the newly created PBIX file and then trying to perform any other transformation, that step is currently not supported.

Source: Using DirectQuery with dataflows - Power BI | Microsoft Learn

That is one possible reason that is resulting in loss of query folding.

I hope this information helps. Please do let us know if you have any further queries.
Thank you

[rohit1991]

Hi @PagnumBI 

Yes, this looks like an issue others have noticed recently with Dataflows Gen1 when the Enhanced Compute Engine is on. Query folding can suddenly stop working even if it was fine earlier, and you’ll see exactly what you described no SQL being generated in the diagnostics.

A few things you can try:

• Refresh credentials for the dataflow connection in Power BI Desktop.

• Clear the cache (File >> Options >> Data Load >> Clear Cache) and reopen the file.

• If possible, test the same setup in a Gen2 dataflow, as folding tends to be more consistent there.

• Check if any schema changes happened in the source tables, as even small changes can break folding.

If none of these help, I’d suggest raising a support ticket with Microsoft, as this might be a backend change or temporary service-side bug