Composio connects AI agents to Microsoft Power BI so they can work with workspaces, reports, and datasets. Access is limited by the permissions you approve and your account’s existing access.
This guide shows you how to set up OAuth credentials and connect Microsoft Power BI to Composio.
Part 1: Create your Microsoft Entra OAuth app
Step 1: Register the app
1. Open Azure portal → App registrations → New registration. Name your app and choose the organizational accounts you want to support.
2. Select Web, enter this redirect URI and click Register.
https://backend.composio.dev/api/v1/auth-apps/add
The callback registered on your app must match the Redirect URI shown in Composio.
Step 2: Copy your client ID and create a secret
1. Copy the Application (client) ID from Overview.
2. Open Certificates & secrets → New client secret.
3. Enter a description, choose an expiry and click Add.
4. Copy and securely store the secret Value. Use the Value, not the Secret ID. Rotate it before expiry.
Step 3: Add Power BI Service permissions
1. Open API permissions → Add a permission.
2. Select Power BI Service.
3. Choose Delegated permissions.
Permission reference. For listing workspaces, the minimum scope is Workspace.Read.All, requested as https://analysis.windows.net/powerbi/api/Workspace.Read.All. offline_access supports continued access. Reports, datasets and other operations have separate permissions. Choose for your own workflow; the screenshots are examples. Microsoft permission reference.
4. Choose the delegated permissions needed for the operations your integration will use. Then click Add permissions.
5. Review the configured Power BI permission.
Part 2: Connect Microsoft Power BI in Composio
Step 1: Create an auth config
1. In Composio, open Auth Configs and click Create.
2. Search for and select Microsoft Power BI.
3. Enter a config name and click Next.
Step 2: Enter your OAuth credentials
1. Choose OAuth 2.0. Enter the app’s Client id and client-secret Value.
2. Keep the Redirect URI identical to the registered Web callback. Under Scopes, choose permissions required by your integration and supported by your app registration. Click Create Auth Config.
Step 3: Connect your Power BI account
1. Open the auth config and click Connect Account.
2. Sign in with the work or school account you use for Power BI. Its existing license and workspace access still apply.
3. Review the app and requested workspace access, then click Accept. Your tenant may require administrator approval. Leave organization-wide consent unchecked unless your administrator intends tenant-wide approval.
Step 4: Check the connection
1. Return to the auth config’s Accounts tab and confirm the connected account shows Active. Copy the Auth Config ID for your application.
