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-rele...
Dataflow
  • 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!

Mitchvdd's avatar
Mitchvdd
Frequent Visitor
6 years ago

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
    Icon for Helper V rankHelper V
    6 years ago

    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
      6 years ago

      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)

      • vissvess's avatar
        vissvess
        Icon for Helper V rankHelper V
        6 years ago

        Mitchvdd , but power bi dataflow manages the storages in background automatically. One need not have azure datalake to use dataflow. 

        Is the direct query of dataflow require storing it in a custom user datalake.?

        if not, how to get this direct query of dataflow?