# Microsoft Power BI — Pipedream Connect

> Visualize any data and integrate the visuals into the apps you use every day with Power BI, a unified platform for self-service and business intelligence.

- API slug: `microsoft_power_bi` (use in MCP headers and tool keys)
- Auth: OAuth (Pipedream-managed)
- Categories: Data Analytics
- Website: https://www.microsoft.com/en-us/power-platform/products/power-bi
- Managed OAuth scopes: `offline_access` · `https://analysis.windows.net/powerbi/api/App.Read.All` · `https://analysis.windows.net/powerbi/api/Dashboard.Read.All` · `https://analysis.windows.net/powerbi/api/Workspace.Read.All` · `https://analysis.windows.net/powerbi/api/Dataset.ReadWrite.All` · `https://analysis.windows.net/powerbi/api/Report.Read.All` · `https://analysis.windows.net/powerbi/api/Report.ReadWrite.All`
- This page (HTML): https://pipedream.com/apps/microsoft-power-bi
- Tools: 15 actions · 3 triggers

## Connect via MCP (recommended)

- Endpoint: `https://remote.mcp.pipedream.net/v3`
- Headers: `Authorization: Bearer <token>` · `x-pd-project-id` · `x-pd-environment` · `x-pd-external-user-id` · `x-pd-app-slug: microsoft_power_bi`

```ts
import { Client } from "@modelcontextprotocol/sdk/client/index.js"
import { StreamableHTTPClientTransport } from "@modelcontextprotocol/sdk/client/streamableHttp.js"
import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const accessToken = await pd.rawAccessToken

const transport = new StreamableHTTPClientTransport(
  new URL("https://remote.mcp.pipedream.net/v3"),
  {
    requestInit: {
      headers: {
        Authorization: `Bearer ${accessToken}`,
        "x-pd-project-id": process.env.PIPEDREAM_PROJECT_ID!,
        "x-pd-environment": "production",
        "x-pd-external-user-id": "{external_user_id}", // any stable ID for this user in your system
        "x-pd-app-slug": "microsoft_power_bi",
      },
    },
  },
)

const mcp = new Client({ name: "my-agent", version: "1.0.0" })
await mcp.connect(transport)

const { tools } = await mcp.listTools()

// e.g. run Add Rows to Dataset Table:
const result = await mcp.callTool({
  name: "microsoft_power_bi-add-rows-dataset-table",
  arguments: {
    datasetId: "Dataset ID",
    tableName: "Table Name",
  },
})
```

Docs: [MCP guide](https://pipedream.com/docs/connect/mcp/developers.md)

## API proxy

For a Microsoft Power BI endpoint with no pre-built tool, the proxy forwards your request with the connected user's credentials attached.

```bash
# The path segment is the target URL, URL-safe base64 encoded:
# https://api.powerbi.com/v1.0/myorg/groups

curl "https://api.pipedream.com/v1/connect/{project_id}/proxy/aHR0cHM6Ly9hcGkucG93ZXJiaS5jb20vdjEuMC9teW9yZy9ncm91cHM?external_user_id={external_user_id}&account_id=apn_xxxxxxx" \
  -H "Authorization: Bearer {access_token}" \
  -H "x-pd-environment: production"
```

Docs: [API proxy guide](https://pipedream.com/docs/connect/api-proxy.md)

## SDK

```ts
import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const result = await pd.actions.run({
  id: "microsoft_power_bi-add-rows-dataset-table",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    microsoft_power_bi: { authProvisionId: "apn_xxxxxxx" },
    datasetId: "Dataset ID",
    tableName: "Table Name",
  },
})
```

Docs: [Managed auth guide](https://pipedream.com/docs/connect/managed-auth/quickstart.md) · [Tools guide](https://pipedream.com/docs/connect/components.md)

## Actions (15)

### `microsoft_power_bi-add-rows-dataset-table` — Add Rows to Dataset Table (Write)

Adds new data rows to the specified table within the specified dataset from My workspace. See the documentation

Full schema: https://pipedream.com/apps/microsoft-power-bi/actions/add-rows-dataset-table.md

### `microsoft_power_bi-add-rows-to-push-dataset` — Add Rows To Push Dataset (Write)

Append rows to a table in a Power BI Push Dataset (streaming / realtime data). Only works for datasets created via the REST API with defaultMode: Push — these datasets expose addRowsAPIEnabled: true on the object returned by List Datasets. Use List Datasets first to resolve a dataset name →…

Full schema: https://pipedream.com/apps/microsoft-power-bi/actions/add-rows-to-push-dataset.md

### `microsoft_power_bi-cancel-refresh` — Cancel Dataset Refresh (Write)

Cancels a refresh operation for a specified dataset in Power BI. See the documentation

Full schema: https://pipedream.com/apps/microsoft-power-bi/actions/cancel-refresh.md

### `microsoft_power_bi-create-dataset` — Create Dataset (Write)

Creates a new Push Dataset in Power BI. See the documentation

Full schema: https://pipedream.com/apps/microsoft-power-bi/actions/create-dataset.md

### `microsoft_power_bi-execute-dax-query` — Execute DAX Query (Read-only)

Execute a DAX (Data Analysis Expressions) query against a Power BI dataset (semantic model). This is the primary analytics tool — use it to answer questions about values, aggregates, or filtered rows in a dataset. Use List Datasets first to resolve a dataset name → datasetId. The query must be a…

Full schema: https://pipedream.com/apps/microsoft-power-bi/actions/execute-dax-query.md

### `microsoft_power_bi-export-report` — Export Report (Write)

Export a Power BI report to a file format such as PDF, PPTX, or PNG. Requires a report ID (use List Reports to find it) and defaults to PDF if no format is given. Pass workspaceId (from List Workspaces) or workspaceName to target a specific workspace, or omit both for My workspace. Supported format…

Full schema: https://pipedream.com/apps/microsoft-power-bi/actions/export-report.md

### `microsoft_power_bi-get-dataset-refresh` — Get Dataset Refresh (Read-only)

Triggers a refresh operation for a specified Power BI dataset. See the documentation

Full schema: https://pipedream.com/apps/microsoft-power-bi/actions/get-dataset-refresh.md

### `microsoft_power_bi-get-refresh-history` — Get Refresh History (Read-only)

Get the refresh history for a Power BI dataset. Use List Datasets first to resolve a dataset name → datasetId. Pass workspaceId (from List Workspaces) or workspaceName to scope to a specific workspace, or omit both for My workspace. Each entry includes requestId, refreshType (OnDemand, Scheduled…

Full schema: https://pipedream.com/apps/microsoft-power-bi/actions/get-refresh-history.md

### `microsoft_power_bi-get-reports-by-id` — Get Report by id (Read-only)

Retrieve metadata for a single Power BI report by ID. Uses My workspace by default; set Workspace (Group) ID for a specific workspace. See the documentation

Full schema: https://pipedream.com/apps/microsoft-power-bi/actions/get-reports-by-id.md

### `microsoft_power_bi-get-reports` — Get Reports (Read-only)

Get reports from a Power BI workspace. See the documentation

Full schema: https://pipedream.com/apps/microsoft-power-bi/actions/get-reports.md

### `microsoft_power_bi-list-dashboards` — List Dashboards (Read-only)

List Power BI dashboards in a workspace. Defaults to the authenticated user's personal My workspace when no workspace is specified. Pass workspaceId (preferred, from List Workspaces) OR workspaceName to scope to a specific workspace. Each dashboard includes id, displayName, isReadOnly, webUrl, and…

Full schema: https://pipedream.com/apps/microsoft-power-bi/actions/list-dashboards.md

### `microsoft_power_bi-list-datasets` — List Datasets (Read-only)

List Power BI datasets (semantic models) in a workspace. Defaults to the authenticated user's personal My workspace when no workspace is specified. Pass workspaceId (preferred, from List Workspaces) OR workspaceName to scope to a specific workspace. Each dataset includes id, name, webUrl…

Full schema: https://pipedream.com/apps/microsoft-power-bi/actions/list-datasets.md

### `microsoft_power_bi-list-reports` — List Reports (Read-only)

List Power BI reports in a workspace. Defaults to the authenticated user's personal My workspace when no workspace is specified. Pass workspaceId (preferred, from List Workspaces) OR workspaceName to scope to a specific workspace — the tool resolves the name to an ID server-side. Each report…

Full schema: https://pipedream.com/apps/microsoft-power-bi/actions/list-reports.md

### `microsoft_power_bi-list-workspaces` — List Workspaces (Read-only)

List the Power BI workspaces (groups) the authenticated user can access. Use this tool first whenever the user refers to a workspace by name — it returns the id you need to pass as workspaceId to other tools. Power BI has no /me endpoint, so the set of accessible workspaces is the user's primary…

Full schema: https://pipedream.com/apps/microsoft-power-bi/actions/list-workspaces.md

### `microsoft_power_bi-refresh-dataset` — Refresh Dataset (Write)

Trigger a refresh of a Power BI dataset. Returns 202 Accepted on success; the request ID is available in the Location response header (last path segment) and x-ms-request-id header — use Get Refresh History to check status. Use List Datasets first to resolve a dataset name → datasetId. Pass…

Full schema: https://pipedream.com/apps/microsoft-power-bi/actions/refresh-dataset.md

## Triggers (3)

### `microsoft_power_bi-dataset-refresh-completed` — Dataset Refresh Completed (Polling)

Emit new event when a dataset refresh operation has completed. See the documentation

Full schema: https://pipedream.com/apps/microsoft-power-bi/triggers/dataset-refresh-completed.md

### `microsoft_power_bi-dataset-refresh-failed` — Dataset Refresh Failed (Polling)

Emit new event when a dataset refresh operation has failed in Power BI. See the documentation

Full schema: https://pipedream.com/apps/microsoft-power-bi/triggers/dataset-refresh-failed.md

### `microsoft_power_bi-new-dataset-refresh-created` — New Dataset Refresh Created (Polling)

Emit new event when a new dataset refresh operation is created. See the documentation

Full schema: https://pipedream.com/apps/microsoft-power-bi/triggers/new-dataset-refresh-created.md

---

- All apps: https://pipedream.com/apps — index: https://pipedream.com/llms.txt
- Pipedream docs for agents: https://pipedream.com/docs/llms.txt