Dataflows Direct Query

[tmckenzie3]

Dataflows would be really useful if you could connect to them via DirectQuery. This would mean that we could query enormous dataflows that are not practical to load to the Data model and can make aggregate dataflows that we load to the Data model. Unsure if this is possible with the architecture of a Dataflow, but it could be quite handy if it is possible.

[bachovak1]

This is all I can see: https://www.screencast.com/t/qZTMKGCr - no changes and no options to enable Direct Query for Dataflows in tenant settings for Power BI.

[mvddobbelsteen]

Is this already available? Because it should be released in April.

[cvinas1]

'@937627150-maignan, can you post an screenshot? Is this a tenant setting that has to be enabled?

[didierma]

This request has now general available (GA) status, I can confirm on our French tenant.

[nico_lagreste1]

Any update on this?

[RakeshSingh]

'Hello Admin - we need more details about this feature: - when is general availability planned? - I don't see an option to connect directly when connecting using getdata-> powerbi dataflows. Data is being loaded into the model ( increase in size of PBI file) and in advanced property of the model view option to change storage mode -> direct query provides following error: Import tables cannot be converted to direct query. FYI - enhanced option is enabled in premium capacity and enhanced metadata preview disabled in PBI desktop. How is this feature supposed to work?

[Martin_Kmec]

Idea should be marked as Implemented. Feature already available: - https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-configure-consume#consuming-a-dataflow - https://ssbipolar.com/2020/10/07/directquery-and-dataflows-in-power-bi/

[nishalit]

This has been released: Power BI June 2021 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI