Dataflows with Direct Query

[Johann_32]

Hello,

in our company we are using Dataflows to let our users connect to the on-premise datasources (via a on premise data gateway).

Is there a way to benefit from the 15 min refresh rate that would come with Direct Query? I understand that to use Direct Query with Dataflows, the Enhanced Compute Engine must be turned on, but does the 15 min refresh rate with direct query get transferred to the Dataset that the user creates when connecting to the dataflow?

Currently I dont think so, as every dataset has its own scheduled refresh.

What would be the right set up to pass the 15 min refresh rate through, from the dataflow to the dataset, and finally to be visualized in a Dashboard (Automatic Page Refresh).

If the dataflow is updated every 15 minutes, but the dataset is still on 8 (pro)/48(premium) times refresh a day, it doesnt make much sense.

Thank you

Johann

[ibarrau · Accepted solution]

Hi. The first thing to way is that Dataflows import its data. Dataflow won't have direct query and 15 mins refresh. Dataflow works with import data and has the same limitations as datasets, so 8 refreshes for pro and 48 for dedicated capacity. The direct query can be built for a dataset to connect a dataflow (this requires premium, ppu or embedded).

Unless you refresh the dataflow many times a day, the direct query from dataset to dataflow doesn't make much sense. You can even build a power automate to refres one after the other one.

You can read more about this here: https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-directquery

I hope that helps,