The Power BI self-service connector allows Experience Managers to embed and access Power BI reports directly within Cemantica.

This integration enables:

A unified view of analytics and experience insights
Centralized access to Cemantica and Power BI reports

This article explains how the connector works, how to configure it, and how security and authentication are managed.

How the Connector Works

Once configured in the Integration Center, the Power BI connector enables users to:

Access Power BI reports inside the Reports menu in Cemantica
View both built-in Cemantica reports and connected Power BI reports

Report visibility follows Power BI permissions. If a user does not have access to a report in Power BI, they will not see it in Cemantica.

Adding Power BI Reports

Only users with the Admin role in Cemantica can add Power BI reports.

To add a report:

Go to Reports
Click the "+" button
Select the Power BI connection
Choose the relevant workspace
Configure the report parameters

Note: You will only see workspaces that the Power BI Admin has granted access to.

Editing or Deleting Power BI Reports

Only Admin users can edit or delete reports.

To edit or delete:

Navigate to Reports
Click the three-dot menu next to the report
Select Edit or Delete

How to Connect Cemantica to Power BI

This section is intended for technical administrators responsible for configuring integrations.

Step 1: Access the Integration Center

Go to Settings
Open the Integration Center
Select the option to configure a Power BI connection

Notes:

Only Admin users have access to the Settings menu.
You can connect multiple Power BI instances.

Step 2: Provide Power BI Configuration Details

You must retrieve configuration data from Power BI and enter it into Cemantica.

Required fields:

Name
Choose a clear name (e.g., "Power BI Reports")
Azure Tenant ID
The Tenant ID of the Azure tenant hosting Power BI
Client ID
From the Registered Azure App that will be used to authenticate Cemantica with Power BI
Client Secret
From the Registered Azure App that will be used to authenticate Cemantica with Power BI

These credentials are created during the Azure AD application registration process (see Security section below).

Step 3: Test the Connection

After configuration:

Go to Reports under the Measure menu
Click the "+" button
Select your configured connection
Click Workspace

If configured correctly, you will see the list of available Power BI workspaces.

Azure AD Configuration Requirements

To connect Cemantica with Power BI, the following steps must be completed by someone with:

Rights to register applications in the Azure tenant
Administrative access to the Power BI Admin Portal

Step 1: Register an Azure AD Application

Create a new Registered App in Azure AD.

This app will be used to authenticate Cemantica with Power BI.

Step 2: Assign Power BI API Permissions

Assign the following delegated permissions to the app:

Power BI Service API permissions required to access workspaces and reports

After assigning permissions:

Create a new Client Secret
Recommended expiry: 24 months
Copy and securely store:
- Client ID
- Client Secret value

Important: The secret value is shown only once. It must be saved immediately.

Step 3: Enable Service Principal Access

In the Power BI Admin Portal, enable service principals to call public Fabric APIs.

Access via:
https://app.powerbi.com/admin-portal/tenantSettings?experience=power-bi

Step 4: Grant Workspace Access

The Registered App must be added as Viewer in all Power BI workspaces that need to be accessible from Cemantica.

Without this step, reports from those workspaces will not appear in Cemantica.

Permissions Summary

Area	Controlled By
Adding / editing reports in Cemantica	Cemantica Admin role
Report content visibility	Power BI permissions
Workspace access	Power BI workspace roles
API authentication	Azure AD Registered App