Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
Lucas_Neves
New Member

Dataflow with DirectQuery - "This step results in a query that is not supported in DirectQuery mode"

Hello everyone,

             

          I am currently experiencing issues when connecting Power BI Desktop to my Dataflow.

          I created a Dataflow that retrieves a view from my SQL Database. After setting up the Dataflow, I enabled the Enhanced Compute Engine in the Dataflow settings and refreshed the Dataflow, as required by this Microsoft article

 

         The problem arises when I open a blank Power BI file and load that view from the Dataflow. I attempt to change the connection mode to DirectQuery under Applied Steps > Source, but I receive the following error: "This step results in a query that is not supported in DirectQuery mode."

          I haven’t added any steps in the data manipulation process.

         

         Does anyone know what could be causing this issue and how to fix it?

 

 

Thanks in advance!

 

3 REPLIES 3
matdriks
New Member

Yes We have the same issue.
First step is to connect to the source and second step is navigation. 
All this automatically generated, but still it cannot use Direct query (yes we are using premium capacity)

Anonymous
Not applicable

Hi All,

Fisrtly, amitchandak thanks you for your reply!
And @MalvikaBhasin ,

Has your problem been solved after all this time, or has a new problem arisen, if there are any other questions on this issue, feel free to contact me and I'll get back to you as soon as I receive the message.

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Lucas_Neves , Make sure you are using a PPU or Premium Capacity workspace. If you are using an existing report that has been published, ensure it was in a Premium Capacity workspace.

Let it add as import mode, and check if it adds any steps like changing the datatype, etc. That can cause issues. Make sure all Change Type steps are handled in the Dataflow.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.