Discover Power BI assets, retrieve TMDL, and run DAX queries securely.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "powerbi-mcp" yet — see the docs or source repo.
List the Power BI workspaces I can access and the datasets inside each workspace, grouped by workspace.
A grouped list of workspaces and datasets for quickly locating queryable data assets.
Retrieve the semantic model definition (TMDL) for a specified Power BI dataset and summarize its main tables and measures.
The tool returns the dataset's TMDL content and highlights key model structure details.
Run a DAX query against a specified dataset to calculate sales by product category for the last 30 days.
A result table from the DAX query, ready for further analysis or reporting.
When analysts or developers need to understand which Power BI workspaces and datasets they can access, this tool helps them discover available assets quickly. It reduces the need to manually browse the platform one item at a time.
Before working with an existing BI model or writing queries, users can retrieve the TMDL definition to understand tables, relationships, and measures. This is useful for model review and query preparation.
When users want analytical results directly through the Power BI and Microsoft Fabric REST APIs, they can use this tool to execute DAX queries. It is suitable for pulling results from semantic models for further analysis.
It is used to discover Power BI workspaces and datasets, retrieve semantic model definitions (TMDL), and execute DAX queries. It works through the Power BI and Microsoft Fabric REST APIs.
The description says it uses MSAL/WAM authentication with secure token caching. For exact setup details, see the source repository.
Its focus is API-based discovery of workspaces and datasets, retrieval of TMDL, and execution of DAX queries. In other words, it is better suited for programmatic access and analysis workflows.
Discover and connect Power BI workspaces and semantic models for data access.
Discover Power BI assets, run DAX, and generate executive HTML reports.
Connect to Power BI with natural language to query and refresh data.
Analyze PBIX files, use Power BI APIs, and export reports and models.
Manage Power BI workspaces, datasets, and refreshes using natural language.
Connect to Fabric and Power BI semantic models for browsing, querying, and optimization.