# Power BI Tabular

> Use this tool when you need to interact with Power BI Desktop tabular models for data analysis and DAX query execution. It solves problems related to model optimization, troubleshooting complex calculations, and DAX development by providing a direct connection between AI assistants and locally running Power BI models. With inputs including DAX queries and outputs such as data previews and metadata, use Power BI Tabular in Windows environments for advanced analysis and AI-assisted Power BI development.

Canonical page: https://skillsregistry.net/skills/jonaolden-powerbi-tabular  
JSON: https://api.skillsregistry.net/v1/skills/jonaolden-powerbi-tabular

## Description

The Tabular MCP Server (MCPBI) connects AI assistants to locally running Power BI Desktop tabular models via ADOMD.NET, enabling direct interaction with Power BI data models for DAX query execution and metadata retrieval. Built in C# for Windows environments, it provides predefined tools for exploring measures, tables, relationships, and data previews, plus flexible DAX query execution with full DEFINE block support for advanced analysis. The server includes automatic Power BI instance discovery, comprehensive security validation, enhanced error reporting with query context, and specialized prompts for DAX debugging, measure design, and relationship analysis, making it valuable for Power BI developers who need AI assistance with DAX development, model optimization, and troubleshooting complex calculations.

## Trust

- **Trust score (0–1):** 1.00
- **Verification tier:** verified
- **Last scanned:** 2026-09-19

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** ai-ml
- **Updated:** 2026-09-19

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/jonaolden-powerbi-tabular)
- **Repository:** <https://github.com/jonaolden/mcpbi>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "jonaolden-powerbi-tabular"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/jonaolden-powerbi-tabular` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/jonaolden-powerbi-tabular/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt