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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
mya
Frequent Visitor

Snowflake to Power Bi Desktop connection using Direct Query

Hi 

I am trying to connect to snowflake datasource using username and password 

and with Direct query to Power Bi Desktop. 

 

I am unable to connect. Is there any prerequisite to be done ? 

Can someone please help on this . Thanks 

7 REPLIES 7
Anonymous
Not applicable

Hi, @mya 

Make sure that DirectQuery mode is selected when connecting to Snowflake. You can connect > Snowflake > by selecting Get Data > Database, and then select DirectQuery. If you set any advanced options, such as command timeouts or role names, double-check that they are correct.

vyohuamsft_0-1727230008404.png

vyohuamsft_1-1727231703232.png

 

To log in to the Snowflake compute warehouse, enter your username and password, and then select Connect.

vyohuamsft_2-1727231795605.png

 

In Navigator, select one or more elements that you want to import and use in Power BI Desktop. Then select Load to load the table in Power BI Desktop, or select Transform data to open Power Query Editor

vyohuamsft_3-1727232101423.png

vyohuamsft_4-1727232175806.png

Or you can try connecting to a Snowflake database from Power Query Online. You can learn more from the following link:

Power Query Snowflake connector - Power Query | Microsoft Learn

 

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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

mya
Frequent Visitor

Can Power Bi service connect to snowflake with direct query mode ?

npetersen20
Frequent Visitor

There shouldnt be a pre-requisite. Just make sure to use the correct server link and do not include https, only the url.

there should be a (unique identifier).snowflakecomputing.com for the server connection.

I am using the link without https , 

1.while login i am providing- user name and password 

2. its getting connected and also datavis getting loaded to power query 

3. Problem is occurring while I am applying the changes to the dashboard. The changes are not getting applied and showing a blank screen . 

sevenhills
Super User
Super User

As per my knowledge, there should not be any issues if you are using Entra ID for DirectQuery.

FYI:

Microsoft Entra ID Single Sign-On (SSO) is only supported for DirectQuery

 

Check this troublshooting link:

https://docs.snowflake.com/en/user-guide/oauth-powerbi#troubleshooting

 

I am using the link without https , 

1.while login i am providing- user name and password 

2. its getting connected and also datavis getting loaded to power query 

3. Problem is occurring while I am applying the changes to the dashboard. The changes are not getting applied and showing a blank screen . 

Sorry, it is not clear what is going wrong in your case.

 

I will only give these extra suggestions to troubleshoot (but not solving your issue)

~ Use Import (instead of Direct Query) to test whether it works or not. Later you can work on DirectQuery Mode. If you are getting lot of rows, then limit to first few thousand rows. Making sure, it works with Import mode. Then try with Entra ID and then try with direct mode.

~ Enable tracing/logs in your power bi desktop and see those and see if it is of any use.

Hope this helps!

Helpful resources

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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