Composio powers 1000+ toolkits, tool search, context management, authentication, and a sandboxed workbench to help you build AI agents that turn intent into action.

next
md 5.75 KB

How do I set up custom OAuth credentials for Microsoft Power BI?

Microsoft Power BI has no Composio-managed app, so you need your own Microsoft Entra ID app registration to connect it.

Create the Microsoft Entra app

  1. Sign in to the Azure portal, open App registrations, and click New registration.
  2. Enter a Name. Under Supported account types, choose an organizational option: Accounts in this organizational directory only (single tenant) or Accounts in any organizational directory (multitenant).
  3. Under Redirect URI, select the Web platform, enter https://backend.composio.dev/api/v1/auth-apps/add, and click Register.
  4. On the app's Overview page, copy the Application (client) ID.

Entra app Overview page with the client, object and tenant IDs censored

  1. Open Certificates & secrets and click New client secret. Add a description, choose an expiry that fits your rotation policy (for example, 180 days), and click Add. Rotate the secret before it expires.

Add a client secret panel with a description and the 180-day expiry

  1. Copy the secret Value right away. Use the Value, not the Secret ID. Azure shows the full value only once; if you lose it, create a new secret.

Client secrets list with the Value and Secret ID columns censored

  1. Open API permissions, click Add a permission, select Power BI Service, and choose Delegated permissions. Add Dataset.Read.All, Report.Read.All, Dashboard.Read.All, Workspace.Read.All, Content.Create, and Dataflow.Read.All, or only the subset your workflow uses. Click Add permissions.

API permissions page with the Add a permission button

Request API permissions panel with Power BI Service under Microsoft APIs

Power BI Service delegated permissions with Workspace.Read.All selected

Configured permissions list on the app's API permissions page

  1. If your tenant restricts user consent, have a tenant admin click Grant admin consent for your tenant on the API permissions page. Adding a permission to the app registration doesn't grant consent by itself.

The redirect URI you register must exactly match the oauth_redirect_uri field in your Composio auth config (default https://backend.composio.dev/api/v1/auth-apps/add).

Entra Authentication page listing the Composio Web redirect URI

Create the auth config in Composio

  1. In the Composio dashboard, go to Auth Configs, click Create, and select Microsoft Power BI. Enter a config name and click Next.

Composio Auth Configs page with the Create button

Create Auth Config dialog with Microsoft Power BI selected

Auth config name field with the Next button

  1. Select OAuth 2.0 and Your Own Credentials. Paste the Application (client) ID into Client id and the secret value into Client secret. Leave Redirect URI as shown.

Composio OAuth 2.0 form with empty Client id and Client secret fields and the v1 redirect URI

  1. Under Scopes, select the same permissions you added in Azure, then click Create Auth Config.

Composio auth config with the v1 redirect URI and the Workspace.Read.All and offline_access scopes

  1. Open the auth config and click Connect Account. Sign in with the work or school account you use for Power BI; its license and workspace access still apply. Review the consent prompt and click Accept. Leave Consent on behalf of your organization unchecked unless you're an admin granting tenant-wide consent. An unverified label is expected for a custom app without a verified publisher.

Microsoft Power BI auth config panel with the Connect Account button

Microsoft Pick an account page with the accounts censored

Microsoft consent prompt to view all workspaces with organization consent unchecked

  1. Back on the auth config's Connected Accounts tab, confirm the account shows Active. The Enabled label at the top of the page describes the auth config, not the account.

Connected Accounts tab with the Power BI account showing Active

For the general flow, see custom auth configs.

Scopes

The default auth config requests the Power BI scopes Dataset.Read.All, Report.Read.All, Dashboard.Read.All, Workspace.Read.All, Content.Create, and Dataflow.Read.All, each prefixed with https://analysis.windows.net/powerbi/api/ (for example, https://analysis.windows.net/powerbi/api/Workspace.Read.All), plus offline_access. Listing workspaces needs only Workspace.Read.All. See Microsoft's get groups reference.