Microsoft Power BI (Client Credentials)

🚀 Quickstart

Connect to Microsoft Power BI with Nango and see data flow in 2 minutes.

Create the integration

In Nango (free signup), go to Integrations -> Configure New Integration -> Microsoft Power BI (Client Credentials).

Connect Microsoft Power BI

Go to Connections -> Add Test Connection -> Connect, then enter your Tenant ID, Client ID, and Client Secret. Later, you’ll let your users do the same directly from your app.

Call the Microsoft Power BI API

Let’s make your first request to the Power BI API (list the workspaces your service principal can access). Replace the placeholders below with your API key, integration ID, and connection ID:

cURL
Node

curl "https://api.nango.dev/proxy/v1.0/myorg/groups" \
  -H "Authorization: Bearer <NANGO-API-KEY>" \
  -H "Provider-Config-Key: <INTEGRATION-ID>" \
  -H "Connection-Id: <CONNECTION-ID>"

Install Nango’s backend SDK with npm i @nangohq/node. Then run:

import { Nango } from '@nangohq/node';

const nango = new Nango({ apiKey: '<NANGO-API-KEY>' });

const res = await nango.get({
    endpoint: '/v1.0/myorg/groups',
    providerConfigKey: '<INTEGRATION-ID>',
    connectionId: '<CONNECTION-ID>'
});

console.log(res.data);

Or fetch credentials with the Node SDK or API.✅ You’re connected! Check the Logs tab in Nango to inspect requests.

Implement Nango in your app

Follow our Auth implementation guide to integrate Nango in your app.To obtain your own production credentials, follow the setup guide linked below.

API gotchas

Power BI’s app-only auth isn’t gated by Microsoft Graph permissions alone — a Power BI tenant admin must also enable Allow service principals to use Power BI APIs (and, if scoping to a security group, add the app to that group) in the Fabric admin portal’s tenant settings. Without this, requests fail even with a valid token and correct application permissions.

A service principal only sees workspaces it’s been added to as a viewer, contributor, member, or admin (/v1.0/myorg/groups). To read tenant-wide without per-workspace membership, use the Admin API (/v1.0/myorg/admin/groups) — this requires enabling Service principals can access read-only admin APIs in the Fabric admin portal (separate from the base tenant setting above). No Microsoft Entra API permission is needed: Tenant.Read.All/Tenant.ReadWrite.All are delegated-only scopes and don’t apply to service principals.

Overview

800+ APIs & Integrations

Microsoft Power BI (Client Credentials)

🚀 Quickstart