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!

vissvess's avatar
vissvess
Helper 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
    Helper 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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Enhanced Dataset format has to be disabled as mentioned in the microsoft document but still am facing the issue where it is asking me to switch to import mode. Look here 

    • Mitchvdd's avatar
      Mitchvdd
      Frequent Visitor
      6 years ago

      Hi AArohatgi,

       

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