Skip to main content

How to Connect Snowflake to Power BI Desktop

Select Snowflake in Power BI Desktop​

  1. In Power BI Desktop, click Get Data.
Get Data option in Power BI Desktop
  1. Search for Snowflake in the search bar, select the connector, and click Connect.
Snowflake connector in Power BI Desktop

Identify the server and warehouse​

  1. Open Snowflake from the Dadosfera platform.
Opening Snowflake from Dadosfera
  1. Click your user in the lower-left corner and select Connect a tool to Snowflake.
Connect a tool to Snowflake option
  1. Use the Account locator value to build the Server field requested by Power BI Desktop.
Snowflake account locator
  1. To fill the Server field in Power BI, take the value shown in Account locator and add .us-east-1.snowflakecomputing.com.

Example: myaccount.us-east-1.snowflakecomputing.com

  1. To identify the warehouse, run the following query in a Snowflake worksheet:
SELECT CURRENT_WAREHOUSE();
  1. In the Warehouse field in Power BI, enter the value returned by the SQL query above.

Example: COMPUTE_WH

Identify your username and password​

  1. To identify your username, open Connect a tool to Snowflake again and copy the value shown in the User name field.
Snowflake username information
  1. Your password is the same one you use to sign in to Dadosfera.
  2. Click Connect in Power BI.