Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
When is Direct Query from Dataflows available? I should be available already, because they announced it to be in Public Preview in April 2020.
Solved! Go to Solution.
Hi AArohatgi,
Have you enabled the 'Enhanced Compute Engine' for Dataflows and reloaded the Dataflow? This was the solution for me!
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.
@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?
@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)
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
Hi AArohatgi,
Have you enabled the 'Enhanced Compute Engine' for Dataflows and reloaded the Dataflow? This was the solution for me!
@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?
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.
Hey @Mitchvdd
I guess the team is also affected by the COVID.
Regards,
Tom
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
For further updates, please check with the below link.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/35976663-dataflows-direct-query
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
30 | |
24 | |
22 | |
21 |
User | Count |
---|---|
58 | |
41 | |
25 | |
24 | |
23 |