Snowflake to Power Bi Desktop connection using Direct Query

[mya]

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 

[v-yohua-msft]

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.

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

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

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]

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

[npetersen20]

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.

[mya]

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]

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

[mya]

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]

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!