--- title: Power BI API Integration on Truto slug: powerbi category: Business Intelligence canonical: "https://truto.one/integrations/detail/powerbi/" --- # Power BI API Integration on Truto **Category:** Business Intelligence **Status:** Generally available ## Unified APIs ### Unified User Directory API - **Roles** — The Role object represents a role of a User. - **Users** — The User object represents a User. - **Workspaces** — Workspaces represent concepts like teams, workspaces, projects in apps that support them ## How it works 1. **Link your customer's Power BI account.** Use Truto's frontend SDK; we handle every OAuth and API key flow so you don't need to create the OAuth app. 2. **Authentication is automatic.** Truto refreshes tokens, stores credentials securely, and injects them into every API request. 3. **Call Truto's API to reach Power BI.** The Proxy API is a 1-to-1 mapping of the Power BI API. 4. **Get a unified response format.** Every response uses a single shape, with cursor-based pagination and data in the `result` field. ## Use cases - **Provision Power BI workspaces when customers onboard** — SaaS platforms that manage organizational structures can automatically create Power BI workspaces and assign user roles during customer onboarding, eliminating manual IT setup and ensuring every team has the right analytics environment from day one. - **Sync user roles and permissions across your app and Power BI** — When your SaaS product manages user hierarchies or team structures, keeping Power BI workspace memberships and role assignments in sync ensures that access controls in your app are consistently reflected in your customers' BI environment. - **Automate workspace access management based on org changes** — Enterprise customers expect that when employees change roles or leave the company, their Power BI access updates automatically. SaaS platforms managing workforce data can trigger these changes without requiring IT intervention. - **Push your SaaS data into customer Power BI environments** — Enterprise buyers often mandate that vendor data flows into their centralized BI stack. By integrating with Power BI, your SaaS product can push datasets directly into customer workspaces so their analysts can blend your data with internal sources. - **Offer embedded Power BI analytics inside your product** — Rather than building a custom reporting engine, SaaS companies can leverage Power BI's rendering capabilities to embed rich, interactive dashboards directly within their application, giving customers enterprise-grade analytics without leaving the product. ## What you can build - **Automated workspace provisioning on customer signup** — Automatically create dedicated Power BI workspaces for each customer account or department and assign the correct users with appropriate roles. - **Role-based access sync from your app to Power BI** — Map your application's user roles to Power BI workspace roles (Admin, Member, Contributor, Viewer) and keep them synchronized as permissions change. - **User directory sync for Power BI governance** — Pull workspace membership and user role data from Power BI into your platform to provide a unified view of who has access to what across BI assets. - **Org-change-triggered access revocation** — Automatically remove or downgrade Power BI workspace access when users are offboarded, change departments, or lose relevant permissions in your application. - **Workspace and user audit dashboard** — Build an admin console that lists all Power BI workspaces, their members, and role assignments sourced through the integration, giving IT teams a single pane of glass for BI access governance. ## FAQs ### What authentication methods does Power BI use for API access? Power BI APIs authenticate via Microsoft Entra ID (formerly Azure AD) using OAuth 2.0. Truto handles the OAuth flow, token refresh, and consent management so your team doesn't need to manage Microsoft identity plumbing directly. ### What data can I access through Truto's Unified User Directory API for Power BI? The Unified User Directory API maps to Power BI's workspace (group) and user management concepts, giving you access to Users, Roles, and Workspaces. This lets you read and manage who has access to which workspaces and at what permission level. ### Are Power BI-specific tools available out of the box on Truto? Power BI tools beyond the Unified User Directory API are built on request. If you need support for datasets, report embedding, dataset refresh triggers, or export operations, Truto can build and ship those endpoints for your use case. ### What are Power BI's API rate limits? Microsoft enforces rate limits on Power BI REST APIs that vary by endpoint and tenant capacity. Truto manages pagination and retry logic automatically, helping you stay within limits without custom backoff handling in your code. ### Can I manage Row-Level Security (RLS) assignments through this integration? RLS configuration in Power BI is primarily defined within the dataset model itself (via DAX roles). However, workspace-level user and role management through the Unified User Directory API is a prerequisite for effective RLS enforcement, since users must have the correct workspace access to be governed by RLS rules. ### Does this work with Power BI Premium and Pro workspaces? Yes. The Power BI REST APIs that Truto connects to support both Pro and Premium workspaces. The specific features available (e.g., large dataset support, deployment pipelines) depend on the customer's Power BI license tier.