cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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/dataflo...

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: Direct Query Dataflows?

Hi AArohatgi,

 

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

View solution in original post

10 REPLIES 10
Highlighted
Super User III
Super User III

Re: Direct Query Dataflows?

Hey @Mitchvdd 

 

I guess the team is also affected by the COVID.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Highlighted
Frequent Visitor

Re: Direct Query Dataflows?

Hi @TomMartens,

 

That makes perfect sense, but I'm working on setting up an architecture where Direct Query on Dataflows would help me enormously. I would like to know when this is available so that I can communicate that too.

 

Kind regards,

 

Mitch

Highlighted
Memorable Member
Memorable Member

Re: Direct Query Dataflows?

@Mitchvdd 

For further updates, please check with the below link.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/35976663-dataflows-direct-query

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

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @

 

BR

venal.

Highlighted
New Member

Re: Direct Query Dataflows?

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.

Highlighted
Frequent Visitor

Re: Direct Query Dataflows?

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.

 

DirectQuery Dataflows.png

Highlighted
Helper IV
Helper IV

Re: Direct Query Dataflows?

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

Highlighted
Frequent Visitor

Re: Direct Query Dataflows?

@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)

Highlighted
Helper IV
Helper IV

Re: Direct Query Dataflows?

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

Highlighted
Frequent Visitor

Re: Direct Query Dataflows?

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 

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors