Power BI

Power BI (via Microsoft Fabric)

Euno integrates with Microsoft Fabric / Power BI, ingesting its metadata to enhance data observability and support proactive, shift‑left practices. By surfacing structure, lineage, and usage patterns across your Power BI environment, Euno enables more informed decision‑making and efficient data management.

Euno's Power BI integration supports auto‑discovery of the following resources and sub‑resources:

  • Power BI workspace

  • Power BI semantic models (Formally known as "datasets")

  • Power BI reports

  • Power BI pages (within reports)

  • Power BI dashboards

  • Power BI tiles (on dashboards)

  • Power BI fields

    • Measures

    • Columns

Power BI Requirements

To ingest metadata from Power BI (Fabric), you will need:

  • Microsoft Entra application / Service Principal with access to target workspaces.

  • Fabric Admin settings:

    • Create a PowerBI application for Euno to use - "Euno PowerBI application"

  • PowerBI admin:

    • Enable API access to various resources for Euno to be able to discover

  • PowerBI app:

    • Grant the Euno's PowerBI application access to the connection and gateway metadata

Stage 1: Configure Azure and PowerBI

Step 1: Create a Euno PowerBI application in Microsoft Entra

  1. Open Microsoft Entra and sign in

  2. In the sidebar, pick "App registrations"

  3. Click "New registration"

  4. Fill in the name ("Euno", for example), leave the "Supported account types" as default ("Accounts in this organizational directory only") and leave the "Redirce URI" empty

  5. Click "Register"

  6. You'll be redirected back to the jOverview page. Make sure to note and copy the Application ID (Also called Client ID) and the Tenant ID (Also called Directory ID). You'll need these in the next steps.

  7. Next, using the sidebar, pick "Certificates & secrets"

  8. Under "Client secrets", click "+ New client secret"

  9. Fill in the expiry time, and optionally a description, and click "Add". This creates a secret for Euno to use to authenticate as the Euno app. Make sure to note and copy the secret Value.

Step 2: Create a security group for the Euno application

Note: This step is not strictly required, but highly recommended. As you'll see in the next steps, some privileges of PowerBI can be either granted to the entire organization, or to specific security groups. If you don't configure a security group for the Euno application, you'll need to enable these privileges to then entire organization.

  1. Open the Azure portal and sign in

  2. Find the service "Microsoft Entra ID"

  3. In the sidebar, under "Manage", pick "Groups"

  4. Click "+ Add" and "Group"

    • Group type: Security

    • Group name: any name (i.e "Euno application")

    • Group description is optional

  5. Once the group is created, click the link under "Members" to open a modal to add users. Add the Euno application and click "Select" to add the Euno application to the new security group

Step 3: Configure access to Power BI APIs

  1. Open the Power BI admin portal and sign in

  2. Pick "Tenant settings" from the list of admin pages

  3. Scroll to "Developer settings" section find "Service principals can call Fabric public APIs" and expand it. Switch to "Enable" and grant access to the security group we created in Step 2.

  4. Scroll to "Admin API settings" and repease the process for:

  • Service principals can access read-only admin APIS

  • Enhance admin APIs responses with detailed metadata

  • Enhacce admin APIs responses with DAX and mashup expressions

Step 4: Add the Euno PowerBI application to your workspaces

Note: this should be done for every PowerBI workspace

  1. Open PowerBI and sign in

  2. Open "Workspaces" and find the workspace you want to enable. Click the ... next to the name and pick "Workspace access"

  3. Click "+ Add people or groups"

  4. Add the Euno PowerBI application you created in step 1 above, and select it. Make sure to assign the "Admin" role.

Step 5: Add the Euno PowerBI application to your gateways and connection

  1. On the top right, click the "Settings" icon (gear icon) and pick "Manage connections and gateways"

  2. For each connection under "Connections", click the ... next to the name, and select "manage users", search the security group we created in step 2, and add it to the members of that connection

Note: Rotate the client secret per your security policy; expired secrets will cause ingestion failures.

Stage 2: Configure New Power BI Source in Euno

Step 1: Access the Sources Page

  • Open Sources.

  • Select Add New Source and choose Power BI.

Step 2: General Configuration

Configuration
Description

Name*

Enter a name for your source (e.g., "Power BI – Finance").

Tenant ID*

Your Microsoft Entra tenant ID.

Client ID*

The application (client) ID of your SPN.

Client Secret*

The client secret for the app registration.

Power BI URL (optional)

Base URL override for deep links (defaults to https://app.powerbi.com).

Step 3: Scheduling Updates

  • Weekly: set specific days and times.

  • Hourly: define the interval (e.g., every 8 hours).

Step 4: Resource Cleanup

Keep your catalog current by choosing a cleanup strategy (see Resource Sponsorship in Euno):

  • Immediate Cleanup: remove resources not detected in the most recent successful run.

  • No Cleanup: keep resources indefinitely, even if no longer detected.

Step 5: Advanced Settings (Optional)

Configuration
Description

Workspace/Object pattern

Regular expressions to allow/exclude specific workspaces or objects (e.g., .* to match all).

Step 6: Save Configuration

Click Save to begin discovery.

What Euno Discovers

  • Workspaces

  • Datasets (semantic models)

  • Reports and Pages

  • Dashboards and Tiles

  • Apps

  • Model fields: Columns and Measures

Last updated