Skip to main content

    Power BI

    Completed

    Dataflows Direct Query

    Vote (602) Share
    's profile image

    on 09 Nov 2018 20:57:48

    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.

    Administrator on 29 Jun 2021 22:12:43

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

    Comments (37)
    's profile image Profile Picture

    Martin K on 21 Apr 2021 14:47:45

    RE: Dataflows Direct Query

    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/

    's profile image Profile Picture

    Rakesh Singh on 06 Jul 2020 00:14:12

    RE: Dataflows Direct Query

    '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?

    's profile image Profile Picture

    Nico Lagreste on 06 Jul 2020 00:13:53

    RE: Dataflows Direct Query

    Any update on this?

    's profile image Profile Picture

    Mitch van den Dobbelsteen on 06 Jul 2020 00:13:19

    RE: Dataflows Direct Query

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

    's profile image Profile Picture

    Kristina on 06 Jul 2020 00:13:13

    RE: Dataflows Direct Query

    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.

    's profile image Profile Picture

    Cesar Vinas on 06 Jul 2020 00:13:12

    RE: Dataflows Direct Query

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

    's profile image Profile Picture

    Maignan on 06 Jul 2020 00:13:04

    RE: Dataflows Direct Query

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

    's profile image Profile Picture

    Shawn M on 06 Jul 2020 00:11:37

    RE: Dataflows Direct Query

    This is need to keep this platform as the preferred options among competing options.

    Please add this.

    's profile image Profile Picture

    Pedro Sanz on 06 Jul 2020 00:09:49

    RE: Dataflows Direct Query

    Good news, just checking 2020 features, it is planned to go live on april: https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/business-intelligence/dataflows-directquery

    's profile image Profile Picture

    Power BI Ideas Admin on 06 Jul 2020 00:09:30

    RE: Dataflows Direct Query

    Definately a must....it's a backwards step without it.