Power BI

Connect to Power BI

Connect PowerBI to your Codd Semantic Layer

Overview

Connect PowerBI to your Codd Semantic Layer using the standard PostgreSQL connector. Leverage PowerBI's rich visualization and modeling features with your Codd corpus data.

Connection Method: Use PowerBI's PostgreSQL connector to connect to the Codd Semantic Layer. No custom drivers required.

Prerequisites

Codd workspace with at least one corpus

Ensure you have a Codd workspace with at least one corpus created

PowerBI Desktop (latest version recommended)

Install the latest PowerBI Desktop for best compatibility

Codd API key

Generate your API key from Settings → API Keys in your Codd workspace

PowerBI Setup

01

Open PowerBI Desktop

Launch PowerBI Desktop and prepare to connect to your Codd Semantic Layer.

Getting Started:

  1. Open PowerBI Desktop
  2. Click "Get Data" from the Home ribbon
  3. Select "More..." to see all data sources
02

Select PostgreSQL Connector

Choose the PostgreSQL connector to connect to Codd's semantic layer.

In the Get Data dialog:

  1. Navigate to "Database" section
  2. Select "PostgreSQL database"
  3. Click "Connect"
03

Configure Connection

Enter the connection details in the PostgreSQL connection dialog.

Corpus Name

Select a corpus

The corpus you want to access from PowerBI

Connection Parameters

Server: [Your Codd server URL]
Database: <corpus_name>

Select a corpus above to generate the database name

04

Select Data Connectivity Mode

Choose how PowerBI will connect to your data.

Data Connectivity Mode Options:

  1. Import

    Data is imported into PowerBI. Recommended for smaller datasets and better performance.

  2. DirectQuery

    Data remains in the source. Real-time data but may have performance limitations.

Recommendation: Start with Import mode for better performance and user experience.

05

Authentication

Enter your authentication credentials.

Authentication Details

Username: 1285ec42-1fbb-46c0-b495-0c114b46b8bd/2ec0400f-c33e-4b2c-b9c1-16e1a24aa310/eaaaa00e-4828-479b-a962-49412dccdc4f

Format: tenantId/brainId/userId ( use your own tenantId, brainId and userId) the above username is just an example

Password: Go to API Keys

Use your API key as the password

06

Complete Connection

Final Steps:

  1. Click "OK" in the authentication dialog
  2. Wait for PowerBI to establish the connection
  3. Select the tables/views you want to use
  4. Click "Load" or "Transform Data"

Troubleshooting

Network & Firewall Configuration

  • Whitelist the Codd Semantic Layer endpoint in your firewall
  • If behind corporate firewall, contact your IT team to allow traffic to the server URL
  • Ensure SSL/TLS connections are permitted for secure data transfer
  • Configure proxy settings if required by your network

Common Issues

  • Verify username format: tenantId/brainId/userId
  • Check API key permissions and ensure it hasn't expired
  • Confirm corpus name is exact (case-sensitive)
  • Try Import mode if DirectQuery fails
  • Reconnect in PowerBI after making configuration changes