First-party app
Microsoft Power BI

Microsoft Power BI

List, refresh and export Power BI workspaces, reports and datasets through the Power BI REST API.

stable Analytics & BIProductivity

About

Microsoft Power BI ships in the w6w first-party pack. It declares 18 actions, 2 health checks, and the host runs its code in a sandbox that never sees the credential.

App id
io.w6w.powerbi
Version
0.1.0
Author
w6w
Licence
MIT
Categories
Analytics & BI · Productivity

Overview

Microsoft Power BI’s business-analytics REST API (api.powerbi.com) — a separate surface from Microsoft Graph, with its own Azure AD app registration and its own error contract. This app covers the four resource families every non-admin automation needs: workspaces (Power BI calls them ‘groups’ internally, but every endpoint and this app calls them workspaces), reports, datasets and dashboards.

Workspaces: list, create and delete a workspace, list its members and grant a member access. Reports: list and get report metadata, delete a report, and the asynchronous export flow — start an export to PDF/PPTX/PNG or (for paginated reports) XLSX/DOCX/CSV/XML/MHTML/accessible PDF, poll its status, then retrieve the finished file as base64. Datasets: list and get dataset metadata, trigger a refresh, read refresh history, and execute a single DAX query against a dataset’s model. Dashboards: list dashboards and list a dashboard’s tiles.

Every action accepts an optional workspace ID. Leave it empty and the call reaches ‘My workspace’ — Power BI’s own convention of simply omitting the /groups/{id} path segment, not a separate set of endpoints — or set it to reach a shared workspace instead, exactly the same distinction this pack’s sharepoint app draws between a site’s default document library and a named one.

Admin-only operations (tenant-wide inventory, activity events, encryption keys) are out of scope: every one of them requires a Fabric/Power BI tenant-admin role, which is a different trust level from the workspace-level access this app’s OAuth scopes request.

Build with Microsoft Power BI

Three routes to the same 18 actions. The Workflow tab is generated from Microsoft Power BI's own manifest and carries its real ids, so it is copy-pasteable; the Code and CLI examples are the same call for any action on any app, so every app-specific value in them is a blank you fill in.

Add Workspace User

add-workspace-user

Grant a user, security group or service principal access to a workspace.

Create Workspace

create-workspace

Create a new Power BI workspace.

Delete Report

delete-report

Delete a report from a workspace, or from My workspace when no workspace is given.

Delete Workspace

delete-workspace

Delete a Power BI workspace.

Execute Dataset Query

execute-dataset-queries

Run a single DAX query against a dataset's model and return its result rows.

Export Report To File

export-report-to-file

Start an asynchronous export of a report to a file format. Returns a job to poll.

Get Dataset

get-dataset

Get a single dataset's metadata.

Get Export File

get-export-file

Download a finished report export as base64.

Get Export Status

get-export-status

Check the status of a report export job started by Export Report To File.

Get Report

get-report

Get a single report's metadata.

List Dashboard Tiles

list-dashboard-tiles

List the tiles pinned to a dashboard.

List Dashboards

list-dashboards

List dashboards in a workspace, or in My workspace when no workspace is given.

List Datasets

list-datasets

List datasets in a workspace, or in My workspace when no workspace is given.

List Refresh History

list-refresh-history

List recent refresh attempts for a dataset.

List Reports

list-reports

List reports in a workspace, or in My workspace when no workspace is given.

List Workspace Users

list-workspace-users

List the users, groups and service principals that have access to a workspace.

List Workspaces

list-workspaces

List the workspaces the connected account has access to.

Refresh Dataset

refresh-dataset

Trigger a data refresh for a dataset.

A workflow step names the app and the action, and the editor fills in the connection when you pick one. This is the Step shape from the workflow spec, carrying Microsoft Power BI's real ids.

{
  "manifestVersion": "2",
  "name": "powerbi-example",
  "steps": [
    {
      "id": "add-workspace-user",
      "uses": {
        "app": "io.w6w.powerbi",
        "action": "add-workspace-user",
        "connection": "conn_YOUR_CONNECTION_ID"
      },
      "with": {
        "groupId": "<groupId>",
        "identifier": "<identifier>",
        "principalType": "<principalType>"
      }
    }
  ]
}

Here are some of the things you can do

  • Add Workspace User

    perform
    add-workspace-user
  • Create Workspace

    perform
    create-workspace
  • Execute Dataset Query

    search
    execute-dataset-queries
  • Export Report To File

    perform
    export-report-to-file
  • Get Dataset

    read
    get-dataset

+13 more actions available

Every app-specific value here is a blank you have to fill in. An app action is reached through the connection that authenticates it, so the address is a connection id, not the app id — and connections belong to your account, so a public page cannot know yours. Create one for Microsoft Power BI, then fill in the three blanks: conn_YOUR_CONNECTION_ID, the action key, and the parameters that action declares. The call itself is real — the shape is transcribed from the studio's own snippet builder, which prints the same kind of blanks — but nothing in it is specific to Microsoft Power BI. The Workflow tab is where this app's real ids are.

Install
npm install @w6w/sdk
yarn add @w6w/sdk
pnpm add @w6w/sdk
deno add npm:@w6w/sdk
Code
import { W6wClient, isActionRun } from "@w6w/sdk";

// Reads W6W_BASE_URL and W6W_TOKEN from the environment when omitted.
const client = new W6wClient();

const envelope = await client.run({
  urn: "conn_YOUR_CONNECTION_ID",
  action: "add-workspace-user",
  payload: {
    groupId: "<value>",
    identifier: "<value>",
    principalType: "<value>",
    groupUserAccessRight: "<value>",
    // displayName: "<value>",
    // emailAddress: "<value>",
  },
});

if (isActionRun(envelope)) console.log(envelope.value);
Install the CLI
npm install -g @w6w/cli
CLI
w6w run conn_YOUR_CONNECTION_ID --action add-workspace-user --payload '{"groupId":"<value>","identifier":"<value>","principalType":"<value>","groupUserAccessRight":"<value>"}'

Give an AI agent Microsoft Power BI — without giving it Microsoft Power BI's credentials. One MCP endpoint exposes every app, function and workflow the caller is entitled to, as tools it can discover and run. Access is granted per team while we onboard.

One tool call
{
  "name": "w6w_invoke",
  "arguments": {
    "ref": "app:io.w6w.powerbi#add-workspace-user",
    "input": {
      "groupId": "<groupId>",
      "identifier": "<identifier>",
      "principalType": "<principalType>"
    }
  }
}

Every tool names its target with a single ref. The app: form above doesn't name a connection at all — the host resolves which of the caller's Microsoft Power BI connections to sign with, and refuses rather than guesses when the answer is ambiguous.

What the agent gets

Credentials it can't read

The token is attached host-side, at the moment of the call. It is never a tool argument, never in the model's context, and never in a transcript — so a prompt injection has nothing to exfiltrate.

A tool surface scoped to the caller

Tools are derived per end user from what that person has actually connected and is entitled to — not one shared bot identity carrying the union of everyone's access.

A durable workflow in one call

Multi-step work runs on the workflow engine and returns a run handle the agent can poll — retries, branching and state survive the conversation that started them.

Health-aware discovery

Microsoft Power BI's declared health checks are on the surface too, so an agent can tell "the vendor is down" from "your credential expired" before it burns a retry on either.

The MCP surface is part of the hosted platform. Microsoft Power BI itself is MIT, and the runtime that executes it is source-available (FSL).

Request MCP access

Health checks

Microsoft Power BI declares its own checks, so its health is a property of the app rather than something the host guesses at.

service

Power BI platform status

quota

API quota headroom