Configure System Objects for Microsoft Power BI Cloud

This article describes the prerequisites for fetching Power BI System Objects: Usage, User Details & Permissions, Log Analytics.

PREREQUISITES:

Usage Dataset

The Usage Dataset is powered by Power BI's Get Activity Events API. These logs form the foundation of adoption and performance analysis, and in Metric Insights appear as Usage data.

Configure Permissions in Azure Portal

NOTE: See the official Microsoft documentation: https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-events.

Requirements

  • The user must be a Fabric administrator or authenticate using a Service Principal.
    • When running under Service Principal authentication, an app must not have any admin-consent required permissions for Power BI set on it in the Azure portal.
    • Tenant.Read.All application permission is required only when authenticating via a standard delegated admin access token. This permission must not be present when authentication via a Service Principal is used.
  • Delegated permissions are supported.

Limitations

  • Maximum 200 requests per hour.
  • Activity logging isn't supported for Microsoft Cloud Deutschland.

Configure Power BI Data Source

v7.2.0+

Access Plugin Connection Profile > Info tab

  1. Enable Usage Dataset.

Prior to v7.2.0

Access Plugin Connection Profile > Info tab

  1. Locate Scope: Types to collect parameter.
  2. Click the edit icon, then add USAGE to the object type list and [Save].

Create a Dataset from Usage System Object

  1. Select the System/Usage object.
  2. MDX/DAX query: Enter param usage_date_to_collect=:measurement_time.
  3. Activate Snapshot Dataset.
  4. Activate Can historical instances be backfilled?
  5. [Validate]

User Details & Permissions Dataset

The User Permissions Dataset is powered by Power BI's Get Workspace Info API, and is essential for BI Optimizer's governance and cleanup.

Configure Permissions in Azure Portal

NOTE: See the official Microsoft documentation: https://learn.microsoft.com/en-us/rest/api/power-bi/admin/workspace-info-post-workspace-info.

Requirements

  • The user must be a Fabric administrator or authenticate using a Service Principal.
  • Tenant.Read.All application permission is required.

Limitations

  • Maximum 500 requests per hour.
  • Maximum 16 simultaneous requests

Configure Power BI Data Source

v7.2.0+

Access Plugin Connection Profile > Info tab

  1. Enable User Permissions Dataset.

Prior to v7.2.0

Access Plugin Connection Profile > Info tab

  1. Locate the Scope: Types to collect parameter.
  2. Click the edit icon, then add USER_PERMISSIONS to the object type list and [Save].

Create a Dataset from Usage System Object

  1. Select System/User Permissions object.
  2. [Validate]

Log Analytics Dataset

See Configure Log Analytics for Power BI Lineage Collection for details.