Connect using Insights Direct Connect from PowerBI to Snowflake

Data Analyst

 

Prerequisites

  • You must have purchased a license for Insights Direct Connect.
  • Download and install Microsoft PowerBI Desktop.

Your Customer Success Manager will provide you with:

  • Connection String and Warehouse Name.
  • Website link to set up your credentials to Snowflake. Before you complete the connection to Snowflake, make sure you follow the link and set up your credentials.

Snowflake Direct Connect

After you have completed the prerequisites, you can set up the connection to Snowflake.

1. Open Microsoft Power BI Desktop.

connect_powerbi1.png

2. From the ribbon menu, click Get Data. The menu expands.

connect_powerbi2.png

3. In the Search field, enter Snowflake. The search result displays.

4. Click on Snowflake.

5. Click the Connect button. The Snowflake dialog displays.

connect_powerbi3.png

6. In the Server field, enter the name of the server. Details are provided by SiQ.

7. In the Warehouse, enter the name of the warehouse. Details are provided by SiQ.

8. Select the Data Connectivity mode, either Import or DirectQuery.

9. Click the OK button. The Snowflake user account dialog displays.

connect_powerbi4.png

10. In the User name field, enter the user name. The user name and password are provided by SpaceIQ.
11. In the Password field, enter the password.
12. Click the Connect button.

When the connection is successful, the shared tables display.

13. Navigate and select the table(s).

14. Click either the Load button or the Transform Data button.

Now you can start to build your visuals and always remember to save your work.