How to Build Power BI reports on Snowflake Data using the DataDirect Snowflake Driver for ODBC

Updated: 04 Jan 2023


Progress DataDirect’s Snowflake ODBC Driver offers a high-performing, secure and reliable connectivity solution, for ODBC applications to access Snowflake data. If you want to use our ODBC Snowflake Driver with the Power BI Desktop application, Progress DataDirect has you covered. In this article, you will learn how you can use Progress DataDirect Snowflake ODBC drivers to import the data from Snowflake Database.  


Install and Configure Progress DataDirect Snowflake ODBC driver

1. Download the Progress DataDirect Snowflake ODBC driver.   


2. Install the Snowflake driver by running Setup.exe. This is a simple installation if you go through with default installation settings.   


3. After the DataDirect Snowflake ODBC driver has been installed, open ODBC Administrator to configure the connection and click on Add.    



4. Choose the “DataDirect X.X Snowflake” and click on “Finish.” 





5. The ODBC Snowflake Driver Setup window will pop up.





Enter your credentials, click on “Apply” and then click on “Test Connect.”    


6. The Snowflake Logon screen will pop up. Provide logon credentials and click on “OK.”    


A screenshot of a computer

Description automatically generated 



7. A dialog box will confirm that the connection is established.    


Connect to an ODBC Data Source using DataDirect Snowflake ODBC driver

1. In Power BI, click on Get Data -> More -> All and search for ODBC. Choose it and click “Connect”.  




 2. A popup menu will appear. From the following dropdown menu select the DSN name. Make sure you select the same driver that you installed. In this case it is Snowflake. Click “Ok”.  





Note: To make it easy remember the Data Source name given during driver setup.  


3. Authenticate using your credentials and click on Connect. 





4. A navigator will open displaying the data in the data source. Choose your database, select table, and click on Load to continue.   




5. You should now see the data as shown below: 




We hope this article helped you with how you can import data into Microsoft Power BI from Snowflake database using Progress DataDirect Snowflake ODBC drivers. Get started today with a free 15-day trial of Progress DataDirect Snowflake ODBC drivers and connect Power BI to all your data!  Contact Us for assistance with any questions you may have, and we will be happy to help! 


Connect any application to any data source anywhere

Explore all DataDirect Connectors

Need additional help with your product?

Get Customer Support