PowerBI changes dataflows from DirectQuery to ImportMode

[jmglpaso_21]

Hi!

We are facing some problems with PowerBI. The problem is that sometimes our tables change from DirectQuery to ImportMode withtout doing nothing. I have searched the internet and cannot find the reason that is causing this problem.

To give some more information, we have about 20 dataflows in DirectQuery format.

[jmglpaso_21]

Hi @amitchandak. 

Our workspace is premiun so it is not the problem.

The strange thing is that if we reload our dataflow, after that changes, sometimes allows us to DirectQuery and sometimes not.

After few refreshes it allows us to DirectQuery that dataflow

[amitchandak]

@jmglpaso_21 , Check your workspace should be premium, and under setting "Enhanced compute engine settings" should be on.