# microsoft-fabric-unified-analytics

microsoft-fabric-unified-analytics walks you through a Fabric analytics stack: OneLake layers, a Dataflow Gen2 cleaning step, PySpark gold tables and Power BI on top.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 282 installs · ★ 5 repo stars
- Author: reason-machines
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/reason-machines/data-skills/tree/HEAD/skills/microsoft-fabric-unified-analytics/SKILL.md
- Updated: 2026-10-09
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/microsoft-fabric-unified-analytics

## What it does

The skill lays out one analytics pipeline on Microsoft Fabric. Raw files land in OneLake as bronze, a Dataflow Gen2 query in Power Query M cleans them into silver, PySpark notebooks in Fabric turn silver into gold KPI tables, and a semantic model feeds Power BI reports above that.

Concrete pieces come with it: the Lakehouse folder layout, an M query that drops duplicate `InvoiceNo`/`StockCode` rows, skips records with no `CustomerID`, adds `line_total`, splits the date into year and month, and flags returns by the “C” prefix on an invoice number. Another snippet refreshes the dataflow through the Fabric REST API using a bearer token from environment variables.

Capacity is the gate. A workspace sits on Fabric capacity, so a Premium or trial licence comes first, and the skill suggests F64 as a starting size. Publishing reports needs Power BI Pro or Premium. Python 3.8+ only matters when you run notebooks on your own machine.

## Requirements
- Works with: Power BI

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill microsoft-fabric-unified-analytics -a claude-code
```

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

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill microsoft-fabric-unified-analytics -a codex
```

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

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill microsoft-fabric-unified-analytics -a cursor
```

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

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install reason-machines/data-skills skills/microsoft-fabric-unified-analytics
```

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

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill microsoft-fabric-unified-analytics -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/reason-machines/data-skills --path skills/microsoft-fabric-unified-analytics
```

### Windsurf (Devin Desktop)

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

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill microsoft-fabric-unified-analytics -a opencode
```

### 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/reason-machines/data-skills/tree/HEAD/skills/microsoft-fabric-unified-analytics/SKILL.md

## When to use it
- split raw CSVs into bronze, silver and gold layers in OneLake
- clean the data in Dataflow Gen2 without writing Python
- compute revenue and average order value in a PySpark notebook
- attach a semantic model to a Power BI report
- trigger a dataflow refresh from a script over the REST API

## Example prompts
- Set up the Fabric Lakehouse with bronze, silver and gold folders and place `online_retail.csv` in the raw layer
- Write a PySpark notebook that aggregates monthly revenue into the gold layer
- Describe a Dataflow Gen2 query that dedupes on `InvoiceNo` and `StockCode` and adds `line_total`

## Similar
- [fabric-lakehouse](https://affpapa.org/en/nevibecode/skills/fabric-lakehouse.md) — skill · 8800 installs
- [fabric-cli](https://affpapa.org/en/nevibecode/skills/fabric-cli.md) — skill · ★ 1104 repo stars
- [azure-mgmt-fabric-py](https://affpapa.org/en/nevibecode/skills/azure-mgmt-fabric-py.md) — skill · ★ 3232 repo stars
- [fabric-data-app](https://affpapa.org/en/nevibecode/plugins/fabric-data-app.md) — plugin · ★ 1104 repo stars
- [Microsoft Fabric MCP Server](https://affpapa.org/en/nevibecode/mcp/microsoft-fabric-mcp-server.md) — MCP server · ★ 3883 repo stars
- [fabric-onelake-2025](https://affpapa.org/en/nevibecode/skills/fabric-onelake-2025.md) — skill · 161 installs

From the same set: [reason-machines/data-skills](https://affpapa.org/en/nevibecode/by/reason-machines/data-skills.md) — 82 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
