Power BI MCP Server

List Workspaces

Returns a list of workspaces (also known as groups) that the user has access to. Workspaces are collaboration spaces where teams can create and share Power BI content like reports, dashboards, and datasets. Use this to discover available workspaces before accessing their content.

Get Workspace

Returns details of a specific workspace by its ID. Provides information such as workspace name, type, state, and whether it's read-only or on dedicated capacity. Use this to verify workspace properties before performing operations within it.

Create Workspace

Creates a new workspace (group) in Power BI. Workspaces are containers for dashboards, reports, datasets, and dataflows that enable collaboration. The workspace is created with the calling user as the initial admin. Use this to set up new collaboration spaces for teams or projects.

Add Workspace User

Grants user permissions to the specified workspace. You can add users with different access levels: Admin (full control), Member (can publish content), Contributor (can edit content), or Viewer (read-only). Use this to manage team access to workspaces and control who can view or edit content.

Delete Workspace User

Removes a user's access to the specified workspace. This revokes all permissions the user had in the workspace, preventing them from accessing its content. Use this when a team member no longer needs access or when restructuring workspace permissions.

List Datasets

Returns a list of datasets from the specified workspace or from My Workspace if no workspace ID is provided. Datasets are collections of data used to create reports and dashboards. Use this to discover available datasets before querying or refreshing them.

Get Dataset

Returns details of a specific dataset by its ID. Provides information such as dataset name, tables, configured parameters, and data source connections. Use this to inspect dataset properties before performing operations like queries or refreshes.

Execute DAX Query

Executes Data Analysis Expressions (DAX) queries against a dataset. DAX is a formula language for creating custom calculations and aggregations. Returns up to 100,000 rows or 1,000,000 values (whichever limit is hit first). Use this to extract specific data, perform calculations, or analyze dataset content. Note: The 'Dataset Execute Queries REST API' tenant setting must be enabled.

Refresh Dataset

Triggers a refresh operation for the specified dataset. Refreshing updates the dataset with the latest data from its data sources. This is an asynchronous operation - use Get Refresh History to check the status. You can specify advanced options like refreshing specific tables or partitions, or applying a refresh policy.

Get Refresh History

Returns the refresh history for the specified dataset. Shows the status, start time, end time, and any error messages for recent refresh operations. Use this to monitor dataset refresh success, troubleshoot failures, or track refresh duration. Results can be filtered using OData parameters.

Get Dataset Datasources

Returns a list of data sources for the specified dataset. Data sources define where the dataset gets its data from (e.g., SQL Server, Azure SQL, Excel files). Use this to understand dataset connections, verify credentials, or troubleshoot data refresh issues.

List Reports

Returns a list of reports from the specified workspace or from My Workspace if no workspace ID is provided. Reports are interactive visualizations built on top of datasets. Use this to discover available reports before viewing, cloning, or exporting them.

Get Report

Returns details of a specific report by its ID. Provides information such as report name, web URL, embed URL, and the dataset it's built on. Use this to get report metadata before performing operations like cloning or embedding.

Clone Report

Creates a copy of the specified report. You can clone the report to a different workspace and give it a new name. The cloned report will reference the same dataset as the original unless you specify a different target dataset. Use this to create report variants or deploy reports across workspaces.

Export Report

Exports the specified report to a .pbix (Power BI Desktop) or .rdl (paginated report) file. The exported file can be downloaded and opened in Power BI Desktop for editing or archival. Use this to backup reports, move them between environments, or enable offline editing.

Get Report Pages

Returns a list of pages within the specified report. Each page represents a different view or tab in the report with its own visualizations and layout. Use this to understand report structure, navigate to specific pages, or validate page names before embedding.

List Dashboards

Returns a list of dashboards from the specified workspace or from My Workspace if no workspace ID is provided. Dashboards are collections of tiles (visualizations) pinned from reports or created with Q&A. Use this to discover available dashboards before accessing their content.

Get Dashboard

Returns details of a specific dashboard by its ID. Provides information such as dashboard name, web URL, embed URL, and whether it's read-only. Use this to get dashboard metadata before accessing its tiles or embedding it.

Get Dashboard Tiles

Returns a list of tiles (visualizations) from the specified dashboard. Each tile represents a pinned visual from a report or a Q&A result. Tiles contain information about their title, position, size, and source report. Use this to understand dashboard layout or access specific visualizations.

Create Dashboard

Creates a new empty dashboard in the specified workspace or in My Workspace. After creation, you can pin tiles to the dashboard from reports or use Q&A to add content. Use this to set up new dashboard containers for organizing visualizations.

List Dataflows

Returns a list of dataflows from the specified workspace. Dataflows are self-service data preparation tools that enable ETL (Extract, Transform, Load) operations in Power BI. They store prepared data that can be used by multiple datasets. Use this to discover available dataflows and their data entities.

Get Dataflow

Returns details of a specific dataflow by its ID. Provides information such as dataflow name, description, configured refresh schedule, and the entities (tables) it contains. Use this to inspect dataflow properties before refreshing or consuming its data.

List Apps

Returns a list of Power BI apps installed for the user. Apps are packaged collections of dashboards and reports that organizations distribute to users. Unlike workspaces, apps provide a curated, read-only experience for consuming content. Use this to discover available apps and their content.

Get App

Returns details of a specific Power BI app by its ID. Provides information such as app name, description, publisher, and the dashboards and reports it contains. Use this to explore app content before accessing specific items within the app.