Forum Discussion

Mitchvdd's avatar
Mitchvdd
Frequent Visitor
6 years ago
Solved

Direct Query Dataflows?

When is Direct Query from Dataflows available? I should be available already, because they announced it to be in Public Preview in April 2020.

 

https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/business-intelligence/dataflows-directquery

  • Mitchvdd's avatar
    Mitchvdd
    6 years ago

    Hi AArohatgi,

     

    Have you enabled the 'Enhanced Compute Engine' for Dataflows and reloaded the Dataflow? This was the solution for me!

10 Replies

  • Wilf's avatar
    Wilf
    New Member

    Good question that I'd love to know the answer to aswell.

     

    I've been searching high and low trying to see if they've hidden the new feature somewhere obscure but can't see it anywhere, so guessing it's not yet dropped.

  • Mitchvdd's avatar
    Mitchvdd
    Frequent Visitor

    In Power BI Desktop the option is already available, but if you select it you will get the message that DirectQuery is not available for Dataflows.

     

    • vissvess's avatar
      vissvess
      Helper V

      Mitchvdd , is that a premium only feature?
      Is that required enabling - "Enhanced dataset format" in PBI Desktop.
      what is the version of PBI desktop you are using?

      • Mitchvdd's avatar
        Mitchvdd
        Frequent Visitor

        vissvess,I don't think it's going to be a premium feature. However, you do need premium to hang your own Data Lake Gen 2 on the Dataflows.

         

        In addition, I think the function "Enhanced dataset format" has nothing to do with Direct Query from Dataflows.

         

        I am using the following version: 2.80.5803.1061 64-bit (April 2020)