Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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
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.
Can Power Bi service connect to snowflake with direct query mode ?
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 .
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!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
68 | |
53 | |
39 | |
33 |
User | Count |
---|---|
70 | |
63 | |
57 | |
49 | |
46 |