Power BI REST API and Automation

Overview

The Power BI REST API provides programmatic access for embedding, administration, dataset management, and automation. The base URL is https://api.powerbi.com/v1.0/myorg/ for user context or https://api.powerbi.com/v1.0/myorg/groups/{workspaceId}/ for workspace context.

Authentication

Service Principal (Recommended for Automation)

1. Register app in Azure AD: Azure Portal > App registrations > New registration
2. Create client secret: Certificates & secrets > New client secret
3. Grant Power BI permissions: API permissions > Add > Power BI Service
4. Enable in Power BI Admin: Tenant settings > Allow service principals to use APIs > add security group
5. Add SP to workspace: Workspace > Access > Add the app as Member or Contributor