Pbirb MCP Server

MCP server for editing Power BI Report Builder paginated reports (RDL)

Local serverstdioPython

What is the Pbirb MCP Server?

MCP server for editing Power BI Report Builder paginated reports (RDL)

What it actually does

An MCP server for editing Power BI Report Builder paginated reports (.rdl) through Claude (Desktop, CLI, or any MCP client). 140+ tools cover the gaps that otherwise force hand-written XML: report creation, data sources and datasets, calculated fields, dataset and tablix filters, groupings (row, column, matrix), sorting, charts, headers and footers, body composition, layout containers, positioning, styling, page setup, pagination, advanced parameters, embedded images, interactivity (actions, tooltips, document map), transactions, and validation.

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

ToolWhat it does
describe_reportTop-level inventory: data sources, datasets, parameters, tablixes, page setup
get_parametersReport parameters with data type, prompt, and flags (multi-value, hidden, nullable, allow-blank)
get_tablixesTablix layout: columns, row/column groups, sort expressions, filters, visibility
get_expression_referenceCheat-sheet of common RDL expression patterns (count_where, sum_where, iif_format helpers build these)
set_datasource_connectionRepoint a <DataSource> at a Power BI XMLA endpoint. DataProvider=SQL (the AS provider id).
update_dataset_queryReplace <DataSet>/<Query>/<CommandText> with a DAX expression
add_query_parameterAppend <QueryParameter> (e.g. =Parameters!DateFrom.Value)
update_query_parameterChange the value expression of an existing query parameter
remove_query_parameterDrop a query parameter (and clean up empty <QueryParameters>)
refresh_dataset_fieldsRe-derive the <Fields> list from the query's column metadata
add_tablix_filterAppend a <Filter>. Operators: Equal, NotEqual, GreaterThan, In, Between, Like, TopN, ...
remove_tablix_filterRemove by ordinal index from list_tablix_filters
convert_to_matrixPromote a table to a matrix (row + column groups) — see [docs/MATRIX-cookbook.md](docs/MATRIX-cookbook.md)
set_tablix_cornerSet the matrix corner cell text/expression

How to install the Pbirb MCP Server

{
  "mcpServers": {
    "pbirb": {
      "command": "uvx",
      "args": ["pbirb-mcp"]
    }
  }
}

Configuration as documented by the project. Restart the client after saving.

Example prompts to try

  • “Use Pbirb to describe report.”
  • “Use Pbirb to get parameters.”
  • “Use Pbirb to get tablixes.”

Frequently asked questions

MCP server for editing Power BI Report Builder paginated reports (RDL) Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.