Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

Connect to Snowflake on Dataflow in DirectQuery mode ?



Is there any way to connect to snowflake in PBI dataflows with DirectQuery mode ? I cannot find specific answer in the documentation and when I tried myself it is not giving me a option

Community Support
Community Support

Hi @Anonymous ,

By default Direct Query is not enabled. In order to use this capability, you you should be a premium Power BI user.

Enable the enhanced compute engine on your premium capacity and go into the dataflow settings section for the dataflow you wish to enable and find the Enhanced compute engine property. Turn this setting to ‘On’ and refresh the dataflow.

Refer to this document: Power BI Dataflows Direct Query Support | Blog de Microsoft Power BI | Microsoft Power BI


Best Regards,
Community Support Team _ kalyj

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

Super User
Super User

Hi. No you can't. Dataflow only store the data. So Import mode only. If you want to use Direct Query against snowflake then use Power Bi Desktop to build a dataset connected that way.

I hope that helps,

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

Happy to help!

LaDataWeb Blog

Not applicable

Thanks for clarifying. Can you give me a documentation link or reference where the same is stated ?

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors