# querying-fabric

querying-fabric is a Claude Code skill that builds and tests DAX queries for Fabric and Power BI semantic models. It prepares data for dashboard KPIs, charts, and tables.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, Windsurf (Devin Desktop), Claude.ai · ★ 1104 repo stars
- Author: Kurt Buhler
- License: GPL-3.0 · policy=link-only · description only; the file stays with the author
- Source: https://github.com/data-goblin/power-bi-agentic-development/tree/HEAD/plugins/dashboards/skills/querying-fabric/SKILL.md
- Updated: 2026-10-28
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/querying-fabric

## What it does

The skill starts by locating a semantic model and reading its schema, then uses existing measures to answer a business question. It creates a separate DAX query for each visual, checks the files with `lint_dax.py`, runs them through `run_dax_query`, and compares results with a known total. T-SQL is covered for Fabric SQL endpoints.

A KPI should include its value, target, and trend. Selecting a mark in one visual should filter the others, with query parameters carrying the selection. The skill also addresses measures that require a currency or period selection. Fix lint errors before running a query; some measures return blank when a required selection is missing.

## Requirements
- Works with: Power BI

## Install

### Claude Code (native platform)

1. **Plugin marketplace**
In the agent chat (not a shell):
```text
/plugin marketplace add data-goblin/power-bi-agentic-development
```
In the agent chat (not a shell):
```text
/plugin install dashboards@power-bi-agentic-development
```
This installs the whole dashboards plugin with all its skills

2. **Skills CLI (Vercel)**
```bash
npx skills add data-goblin/power-bi-agentic-development --skill querying-fabric -a claude-code
```

3. **Manually: put the files in place**
- File: `~/.claude/skills/querying-fabric/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/querying-fabric/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add data-goblin/power-bi-agentic-development --skill querying-fabric -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/querying-fabric/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add data-goblin/power-bi-agentic-development --skill querying-fabric -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/querying-fabric/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install data-goblin/power-bi-agentic-development plugins/dashboards/skills/querying-fabric
```

2. **Manually: put the files in place**
- File: `.github/skills/querying-fabric/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add data-goblin/power-bi-agentic-development --skill querying-fabric -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/data-goblin/power-bi-agentic-development --path plugins/dashboards/skills/querying-fabric
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/querying-fabric/SKILL.md` — The legacy .windsurf/skills/ path still works

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/data-goblin/power-bi-agentic-development/tree/HEAD/plugins/dashboards/skills/querying-fabric/SKILL.md

## When to use it
- find the right measures in a semantic model
- write a DAX query for a KPI or chart
- lint and run queries before wiring up a dashboard
- pass visual selections through crossfilters
- compare a query result with a trusted total

## Example prompts
- Build a KPI from the Power BI model using an existing measure, target, and trend.
- Lint the DAX files in `queries/*.dax`, then run them with `run_dax_query`.
- Wire the dashboard visuals so selecting a dimension filters the others.

## Similar
- [microsoft-fabric-unified-analytics](https://affpapa.org/en/nevibecode/skills/microsoft-fabric-unified-analytics.md) — skill · 282 installs
- [azure-mgmt-fabric-py](https://affpapa.org/en/nevibecode/skills/azure-mgmt-fabric-py.md) — skill · ★ 3232 repo stars
- [sql-jdbc-access-design](https://affpapa.org/en/nevibecode/skills/sql-jdbc-access-design.md) — skill · 10100 installs
- [powerbi-modeling](https://affpapa.org/en/nevibecode/skills/powerbi-modeling.md) — skill · 9934 installs
- [power-bi-report-design-consultation](https://affpapa.org/en/nevibecode/skills/power-bi-report-design-consultation.md) — skill · 9390 installs
- [extension-querying-oql](https://affpapa.org/en/nevibecode/skills/extension-querying-oql.md) — skill · 29000 installs

From the same set: [data-goblin/power-bi-agentic-development](https://affpapa.org/en/nevibecode/by/data-goblin/power-bi-agentic-development.md) — 59 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
