Power BI admin
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect Power BI admin to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Sync tenant-wide Power BI and Fabric governance data: the audit log of views, edits, exports and shares, plus the workspace, semantic model, report, dashboard, dataflow, and capacity inventories.
Create an Entra ID app registration, add a client secret, and put the app in a security group that is allowed to use the read-only admin APIs in the Fabric admin portal. The app must not have any admin-consent Power BI permissions set on it. Then enter the directory (tenant) ID, application (client) ID, and client secret below.
Power BI only serves activity events for the last 28 days, so the first sync starts there and everything after that builds up in your warehouse.
Configuration
| Option | Type | Required |
|---|---|---|
Directory (tenant) ID | text | Yes |
Application (client) ID | text | Yes |
Client secret | password | Yes |
Linking Power BI admin to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Power BI admin
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
activity_events | Tenant audit events (views, edits, exports, shares) for Power BI and Fabric items | Incremental, Full refresh | CreationTime | — |
groups | Every workspace in the tenant, including personal and orphaned workspaces | Full refresh | — | — |
datasets | Every semantic model (dataset) in the tenant | Full refresh | — | — |
reports | Every report in the tenant | Full refresh | — | — |
dashboards | Every dashboard in the tenant | Full refresh | — | — |
dataflows | Every dataflow in the tenant | Full refresh | — | — |
capacities | Premium and Fabric capacities assigned to the tenant | Full refresh | — | — |