Connect to a Snowflake computing warehouse in Power BI Desktop

In Power BI Desktop, you can connect to a Snowflake computing warehouse and use the underlying data just like any other data source in Power BI Desktop.

Connect to a Snowflake computing warehouse

To connect to a Snowflake computing warehouse, select Get Data from the Home ribbon in Power BI Desktop. Select Database from the categories on the left, and you see Snowflake.

Screenshot of the Get Data dialog, showing the Snowflake database selection.

In the Snowflake window that appears, type or paste the name of your Snowflake computing warehouse into the box and select OK. Note that you can choose to Import data directly into Power BI, or you can use DirectQuery. You can learn more about using DirectQuery. Please note that AAD SSO only supports DirectQuery.

Screenshot of the Snowflake dialog, showing the Import radio button selected.

When prompted, put in your username and password.

Screenshot of the Snowflake credential prompt, showing the Username and Password fields.

Note

Once you put in your username and password for a particular Snowflake server, Power BI Desktop uses those same credentials in subsequent connection attempts. You can modify those credentials by going to File > Options and settings > Data source settings.

If you want to use the Microsoft account option, the Snowflake AAD integration must be configured on the Snowflake side. To do this, read the Getting Started section of the Snowflake documentation on the topic.

Microsoft account authentication type in Snowflake connector.

Once you successfully connect, a Navigator window appears and displays the data available on the server, from which you can select one or multiple elements to import and use in Power BI Desktop.

ODBC Error 28000 causing a failure to connect.

You can Load the selected table, which brings the entire table into Power BI Desktop, or you can Edit the query, which opens Query Editor so you can filter and refine the set of data you want to use, and then load that refined set of data into Power BI Desktop.

Next steps

There are all sorts of data you can connect to using Power BI Desktop. For more information on data sources, check out the following resources: