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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
aarishkhan
New Member

Any one have idea about Snowflake direct query mode?

Snowflake direct query mode

1 ACCEPTED SOLUTION
v-nuoc-msft
Community Support
Community Support

Hi @aarishkhan 

 

To connect to Snowflake in Power BI Desktop, you can follow these steps:


On the Home ribbon of Power BI Desktop, select Get Data.


Select "Databases" from the categories on the left, and then select "Snowflake".

 

vnuocmsft_0-1712716095295.png


In the Snowflake pop-up window, enter the name of your Snowflake server into the "Server" field, and the name of your Snowflake compute repository into the "Warehouse" field.

 

vnuocmsft_1-1712716183635.png

 

Select OK.

 

To log in to your Snowflake compute repository, enter your username and password and select Connect.

 

Power Query Snowflake connector - Power Query | Microsoft Learn


If you want to use Microsoft Entra ID for single sign-on (SSO), you need to configure Microsoft Entra ID integration on the Snowflake side.

 

Connect to Snowflake with Power BI - Power BI | Microsoft Learn

 

When you use direct query mode with Snowflake, Power BI sends queries to Snowflake in real time as you interact with reports.


This means that your visualizations are always in sync with the latest data available in Snowflake.

 

Regards,

Nono Chen

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

 

View solution in original post

1 REPLY 1
v-nuoc-msft
Community Support
Community Support

Hi @aarishkhan 

 

To connect to Snowflake in Power BI Desktop, you can follow these steps:


On the Home ribbon of Power BI Desktop, select Get Data.


Select "Databases" from the categories on the left, and then select "Snowflake".

 

vnuocmsft_0-1712716095295.png


In the Snowflake pop-up window, enter the name of your Snowflake server into the "Server" field, and the name of your Snowflake compute repository into the "Warehouse" field.

 

vnuocmsft_1-1712716183635.png

 

Select OK.

 

To log in to your Snowflake compute repository, enter your username and password and select Connect.

 

Power Query Snowflake connector - Power Query | Microsoft Learn


If you want to use Microsoft Entra ID for single sign-on (SSO), you need to configure Microsoft Entra ID integration on the Snowflake side.

 

Connect to Snowflake with Power BI - Power BI | Microsoft Learn

 

When you use direct query mode with Snowflake, Power BI sends queries to Snowflake in real time as you interact with reports.


This means that your visualizations are always in sync with the latest data available in Snowflake.

 

Regards,

Nono Chen

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

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.