Skip to main content
Glama
Mitsubishi-Fuso

MCP Server for Power BI

by Mitsubishi-Fuso
OverviewSchemaRelated ServersScoreDiscussions
Python
Remote

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
PORTNoPort for the HTTP server3001
AUDIENCEYesAPI application ID (audience for JWT)
LOG_LEVELNoLogging levelinfo
TENANT_IDYesAzure AD tenant ID
OBO_CLIENT_IDYesClient ID for On-Behalf-Of flow
REQUIRED_ROLESNoRequired roles for authorizationmcp.user
REQUIRED_SCOPESNoRequired scopes for authorizationmcp.access
OBO_CLIENT_SECRETYesClient secret for On-Behalf-Of flow

Capabilities

Features and capabilities supported by this server

CapabilityDetails
tasks
{
  "list": {},
  "cancel": {},
  "requests": {
    "tools": {
      "call": {}
    },
    "prompts": {
      "get": {}
    },
    "resources": {
      "read": {}
    }
  }
}
tools
{
  "listChanged": true
}
prompts
{
  "listChanged": false
}
resources
{
  "subscribe": false,
  "listChanged": false
}
experimental
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
powerbi_list_workspacesA

List all Power BI workspaces the user has access to.

Returns a list of workspaces with their IDs and names. This is useful for identifying which workspaces you can access and work with.

Common errors:

  • 401 Unauthorized: Token is missing or invalid

  • 403 Forbidden: Token expired or lacks required permissions

get_workspace_idA

Get the workspace ID for a given workspace name.

This tool is useful for finding the workspace ID when you only know the workspace name. The ID is required for other operations like listing datasets.

Args: workspace_name: The display name of the Power BI workspace.

Returns: The workspace ID as a string.

Raises: ToolError: If the workspace is not found.

list_datasets_in_workspaceA

List datasets in the specified workspace.

Args: workspace_id: The unique identifier of the Power BI workspace (UUID format).

Raises: ToolError: If workspace_id is missing or invalid format

get_dataset_detailsB

Retrieve dataset (semantic model) metadata and structure.

Args: workspace_id: The unique identifier of the Power BI workspace (UUID format). dataset_id: The unique identifier of the dataset (UUID format).

Raises: ToolError: If workspace_id or dataset_id is missing or invalid format

execute_dax_queryA

Execute a DAX query against a dataset.

This tool executes DAX (Data Analysis Expressions) queries against Power BI datasets. DAX queries must use the EVALUATE keyword for table expressions.

Args: workspace_id: The unique identifier of the Power BI workspace (UUID format). dataset_id: The unique identifier of the dataset (UUID format). dax_query: The DAX query text to execute. Must start with EVALUATE for table queries.

Returns: Query results with tables and rows, or error information if the query fails.

Common errors:

  • 400 Bad Request: DAX syntax errors, invalid table/column references

  • 403 Forbidden: Missing permissions or tenant setting not enabled

  • Limitations: Max 100,000 rows or 1,000,000 values per query

Example DAX query: EVALUATE TOPN(10, 'Sales')

Raises: ToolError: If parameters are invalid or query execution fails

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/Mitsubishi-Fuso/mcp-server-for-powerbi'

If you have feedback or need assistance with the MCP directory API, please join our Discord server