Day 24 - Use ODBC driver to connect to Oracle/SQL Server DB from POWER BI Desktop
Open Database Connectivity (ODBC) The ODBC Driver for Oracle enables an application to access data in an Oracle database through the ODBC interface. Step 1 : Install ODBC Driver Step 2 : Open ODBC App and Navigate to 'User DSN' > 'Add' to add a new connection Step 3: Select option - 'Oracle in OraClient.......' to add a new oracle DB connection. Please enter details as shown below. Click on Test Connection and enter DB password to test DB connection. You would get below message if connection is successful . Step 4: Launch Power BI Desktop and Navigate to Get Data > ODBC > Connect Select DSN which you have just configured in above step. To avoid extra delay, it's a good practice to enter SQL statement to fetch relevant data from DB. Click on OK Step 5 : Enter user name and password to fetch data from Oracle DB Step 6 : Tada 🎉 🎉 Able to access Oracle DB successfully from POWER BI Desk...