Forum Discussion

frithjof_v's avatar
frithjof_v
Community Champion
1 year ago

Dataflows: Enhanced Compute Engine. Optimized or On?

According to this blog post, the Dataflow connector supports query folding, but only if the Enhanced Compute Engine setting on the dataflow is set to "On":    "2. Dataset refresh operations can als...
Dataflow
GilbertQ's avatar
GilbertQ
Super User
1 year ago

Hi frithjof_v 

 

Yes, this will benefit your refreshers because it will only have to get the data that is needed for the incremental refresh instead of having to query the entire data set.

frithjof_v's avatar
frithjof_v
Community Champion
1 year ago

Thanks GilbertQ ,

 

If I don't use Incremental Refresh or DirectQuery, instead I just use normal Import Mode, does the Dataflow connector support query folding when the Import mode semantic model refreshes in the Power BI service?

 

When I query the Dataflow from Power BI Desktop, I see a big speed boost when I turn the Dataflow's Enhanced Compute Engine setting to "On". When the Enhanced Compute Engine setting is "Optimized", then Power BI Desktop uses longer time to query the Dataflow.

 

However when I publish the same Power BI Semantic Model to the Power BI service, I don't see any noticeable change in refresh time if the setting is "On" or "Optimized".

 

I am using Import Mode, but I am not using Incremental Refresh.

 

Does the Dataflow connector support query folding when refreshing an import mode semantic model in the Power BI service?

 

Thanks!