Power BI: How to Connect to a Denodo Database

Denodo is a leading data virtualization platform that allows real-time integration and access to data across diverse sources without data replication. It enables organizations to deliver faster insights by creating a unified data layer for reporting and analytics.

Power BI is a powerful business intelligence tool that integrates seamlessly with Denodo, allowing users to visualize and analyze virtualized data efficiently. By combining Denodo’s data federation with Power BI’s visualization capabilities, businesses can unlock real-time, consolidated insights.

Connecting to the Denodo database using Power BI Desktop involves the following key steps:

• Installing ODBC drivers for Denodo Virtual DataPort
  
  

• Setting up and configuring the ODBC connection
  
  

• Creating the Denodo connection in Power BI Desktop
  
  

• Retrieving and visualizing data in Power BI

This article provides a step-by-step guide on how to connect to the Denodo database using Power BI Desktop and retrieve data for analysis.

1. Installing ODBC drivers for Denodo Virtual Data Port :

1. Download ODBC drivers for Denodo Virtual Data Port

2. Link- https://community.denodo.com/drivers/odbc/9 

3. Install the ODBC Driver for Denodo
   
   

2. Setting up and configuring the ODBC connection :
   
   

1. Locate the ODBC Data Sources on your computer and open the application.
   
   

2. Open the ODBC Data Sources application, click on System DSN and click on Add
   
   
   
   

3. Select “DenodoODBC” Unicode(x64)”

5. Fill the following details to setup the data source.

Data Source: Denodo Global Sales Management	Description: Denodo Global SALES
Database: Market	SSL Mode: disable
Server: indsqleast0175.bbt.indiaCloudeast1.com	Port: 9996
User Name: svc_sales_analytics	Password:

Note- you should have all the below mentioned information to set up the data source.

6. Click the test button to test whether the connection to the data source is successful or not
   

   
   
   

7. Click on the save button to save the data source/connection details.

3. Connecting Denodo database using Power BI Desktop

1. Open the Power BI Desktop and click on Get Data 🡺 More🡺 Select ODBC

2. From  ODBC Data Source Name (DSN), select the connection created by us – “Denodo Global Sales Management”

3. Provide the credential to connect to the Denodo database and click on connect.

4. Here you can see your database and all the tables/view. Select any table and click on load