Snowflake to Power Bi Desktop connection using Direct Query

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.