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

QuickStart with PostgreSQL: Setup, Connect, and Run Your First SELECT Statement

 PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system known for its stability, extensibility, and SQL compliance. It's widely used in industries ranging from finance and healthcare to technology startups due to its robustness and support for complex queries and data types. Whether you're building a data-driven web application or analyzing large datasets, PostgreSQL offers a scalable and reliable solution.

In this guide, we’ll walk through how to connect to a PostgreSQL server and retrieve data using a simple SQL SELECT statement.

---

Step 1: Install and Register a PostgreSQL Server

To start using PostgreSQL, you first need to install and register a PostgreSQL server:

1.1 Install PostgreSQL

• Download the installer from the official website: https://www.postgresql.org/download/

1.2 Register/Connect to PostgreSQL Server Using pgAdmin

• Open pgAdmin.
  
  

• Right-click on “Servers” → Click Register > Server.
  
  
  

• In the General tab, give your server a name (e.g., Local PostgreSQL).
  

• In the Connection tab:
  
  

• Host: Your Server Name
  
  

• Port: 5432 (default)
  
  

• Username: Your Service Account
  
  

• Password: Enter the one you created during installation
  
  
  
  
  

• Click Save to register and connect to the PostgreSQL server.
  
  

---

Step 2:  Data Retrieval from Table

• Go to the Database from where we need to retrieve the data

• Pressing key ALT + SHIFT + Q which will open the Query Tool

• Write the SELECT Query for any table or view

• Below is an example

• You can see the data from Table

Power BI: Calculate Yearly Running Total of Sales for Region(s) Using DAX

 A Running Total shows the cumulative sum of a measure over a period, helping you track how values build up step-by-step. It’s essential for understanding trends, monitoring progress, and spotting patterns in sales, expenses, or any time-based data. Running totals are widely used in dashboards and reports to give a continuous, easy-to-follow view of performance over time.

Below is the table where we will add a calculated column to compute the Yearly Running Total of Sales Amount by Region using DAX.

The following DAX code calculates the Yearly Running Total of Sales Amount, broken down by region

Sales Amount (RunningTotal) =

CALCULATE (

    SUM ( SalesData[SalesAmount] ),

    FILTER (

        SalesData,

        SalesData[Region] = EARLIER ( SalesData[Region] )

            && SalesData[Year] <= EARLIER ( SalesData[Year] )

    )

)

Result: You can now see the Yearly Running Total of Sales Amount for Region

Power BI: How to create rank using DAX

Ranking in DAX helps bring your data to life by showing who’s leading, who’s trailing, and how everything compares. Whether you're highlighting top products, best-performing regions, or yearly trends, ranking turns plain numbers into clear insights. With functions like RANKX(), you can easily compare performance across different categories—making it a powerful tool for analysis and decision-making.

1. Below is the table in which we will add a column which will compute the rank for the years
   

2. Below is the DAX code for the generating the rank for the years
   Year_Rank =

RANKX( SalesData_All, SalesData_All[Year],, ASC, DENSE )

3. Result - You can see the rank(s) for the Year:
   

Power BI: How to Combine (UNION) Two Tables Using DAX

Merging tables is essential for consolidating data from multiple sources, ensuring a unified view for analysis. The UNION function in DAX allows you to combine two tables with identical columns into a single dataset. It’s a straightforward way to unify data from multiple sources or periods without altering existing relationships, making data integration seamless for analysis.

Below are the two tables that we will combine in Power BI using the UNION function:

1. Table SalesData :
   
   
   

2. Table SalesData_France :
   

3. Below is the code to combine two tables using UNION in DAX:
   SalesData_All =

UNION ( SalesData, SalesData_France )

4. Below is the Table SalesData_All which contains data from both the tables