fabric-cli

Category: Tools & Productivity | Uploader: data-goblin | Downloads: 0 | Version: v1.0（Latest）
This skill should be used when the user asks to "use the Fabric CLI", "run fab commands", "deploy Fabric items", "manage Fabric workspaces", "query a lakehouse", "refresh a semantic model via CLI", "run a Fabric notebook", "manage OneLake files", "automate Fabric operations", or mentions fab, Fabric CLI, or Fabric item management. Provides expert guidance for the fab CLI covering navigation, deployment, jobs, APIs, and automation.
Changelog: Source: GitHub https://github.com/data-goblin/power-bi-agentic-development
Directory Structure

Current level: tree/main/plugins/fabric-cli/skills/fabric-cli/
📁 references/
- 📄 admin.md 5.6 KB
- 📄 create-workspaces.md 600 B
- 📄 dashboards.md 6.4 KB
- 📄 dataflows.md 13.1 KB
- 📄 deployment-pipelines.md 24.0 KB
- 📄 essential-commands.md 11.6 KB
- 📄 fab-api.md 6.2 KB
- 📄 fab-vs-az-cli.md 19.0 KB
- 📄 folders.md 5.1 KB
- 📄 gateways.md 16.5 KB
- 📄 notebooks.md 17.1 KB
- 📄 org-apps.md 7.6 KB
- 📄 paginated-reports.md 16.0 KB
- 📄 querying-data.md 1.2 KB
- 📄 quickstart.md 13.3 KB
- 📄 reference.md 33.8 KB
- 📄 reports.md 5.7 KB
- 📄 scorecards.md 14.2 KB
- 📄 semantic-models.md 16.3 KB
- 📄 workspaces.md 14.7 KB
📁 scripts/
- 📄 create_direct_lake_model.py 7.5 KB
- 📄 download_workspace.py 12.1 KB
- 📄 execute_dax.py 7.4 KB
- 📄 export_semantic_model_as_pbip.py 11.5 KB
- 📄 get-downstream-reports.py 5.6 KB
- 📄 README.md 2.5 KB
- 📄 search_across_workspaces.py 37.1 KB
📄 SKILL.md 15.5 KB
SKILL.md

---
name: fabric-cli
version: 0.10.0
description: This skill should be used when the user asks to "use the Fabric CLI", "run fab commands", "deploy Fabric items", "manage Fabric workspaces", "query a lakehouse", "refresh a semantic model via CLI", "run a Fabric notebook", "manage OneLake files", "automate Fabric operations", or mentions fab, Fabric CLI, or Fabric item management. Provides expert guidance for the fab CLI covering navigation, deployment, jobs, APIs, and automation.
---

# Microsoft Fabric CLI Operations

> **Note:** If you have access to a Bash tool (e.g., Claude Code), execute `fab` commands directly via Bash rather than using an MCP server.

Expert guidance for using the `fab` CLI to programmatically manage Fabric

## When to Use This Skill

Activate automatically when tasks involve:

- Mention of the Fabric CLI, Fabric items, Power BI, `fab`, or `fab` commands
- Managing workspaces, items, or resources
- Deploying or migrating semantic models, reports, notebooks, pipelines
- Running or scheduling jobs (notebooks, pipelines, Spark)
- Working with lakehouse/warehouse tables and data
- Using the Fabric, Power BI, or OneLake APIs
- Automating Fabric operations in scripts

## Critical

- Before first use, ask the user if they have Fabric admin access, any API restrictions, or preferences for Fabric/Power BI API usage
- Remind the user to add their Fabric access level and preferences to their agent memory files (e.g., CLAUDE.md) for future sessions
- If workspace or item name is unclear, ask the user first, then verify with `fab ls` or `fab exists` before proceeding
- The first time you use `fab` run `fab auth status` to make sure the user is authenticated. If not, ask the user to run `fab auth login` to login
- Always use `fab --help` and `fab <command> --help` the first time you use a command to understand its syntax, first
- Always try the simple `fab` command alone, first before piping it
- Always use `-f` when executing command if the flag is available to do so non-interactively
- Ensure that you avoid removing or moving items, workspaces, or definitions, or changing properties without explicit user direction
- If a command is blocked in your permissions and you try to use it, stop and ask the user for clarification; never try to circumvent it
- Use `fab` in non-interactive mode. Interactive mode doesn't work with coding agents

## First Run

```bash
fab auth login          # Authenticate (opens browser)
fab auth status         # Verify authentication
fab config set mode command_line  # Non-interactive mode (required for agents)
fab ls                  # List your workspaces
fab ls "Name.Workspace" # List items in a workspace
```

**Auth methods** (for automation):

```bash
fab auth login -u <client-id> -p <client-secret> --tenant <tenant-id>   # Service principal
fab auth login -u <client-id> --certificate /path/to/cert.pem --tenant <tenant-id>  # Certificate
fab auth login --federated-token <token> -u <client-id> --tenant <tenant-id>  # OIDC
fab auth login --identity                                                # System-assigned managed identity
fab auth login --identity -u <client-id>                                 # User-assigned managed identity
```

## Variable Extraction Pattern

Most workflows need IDs. Extract them like this:

```bash
WS_ID=$(fab get "ws.Workspace" -q "id" | tr -d '"')
MODEL_ID=$(fab get "ws.Workspace/Model.SemanticModel" -q "id" | tr -d '"')

# Then use in API calls
fab api -A powerbi "groups/$WS_ID/datasets/$MODEL_ID/refreshes" -X post -i '{"type":"Full"}'
```

## Command Reference

| Command | Purpose | Example |
|---------|---------|---------|
| **Finding Items** |||
| `fab ls` | List items | `fab ls "Sales.Workspace"` |
| `fab ls -l` | List with details | `fab ls "Sales.Workspace" -l` |
| `fab ls -q` | Filter with JMESPath | `fab ls "Sales.Workspace" -q "[?contains(name, 'Report')]"` |
| `fab exists` | Check if exists | `fab exists "Sales.Workspace/Model.SemanticModel"` |
| `fab get` | Get item details | `fab get "Sales.Workspace/Model.SemanticModel"` |
| `fab get -q` | Query specific field | `fab get "Sales.Workspace" -q "id"` |
| `fab desc` | Check supported commands | `fab desc .SemanticModel` |
| **Definitions** |||
| `fab get -q "definition"` | Get full definition | `fab get "ws.Workspace/Model.SemanticModel" -q "definition"` |
| `fab export` | Export to local | `fab export "ws.Workspace/Nb.Notebook" -o ./backup` |
| `fab import` | Import from local | `fab import "ws.Workspace/Nb.Notebook" -i ./backup/Nb.Notebook` |
| **Running Jobs** |||
| `fab job run` | Run synchronously | `fab job run "ws.Workspace/ETL.Notebook"` |
| `fab job start` | Run asynchronously | `fab job start "ws.Workspace/ETL.Notebook"` |
| `fab job run -P` | Run with params | `fab job run "ws.Workspace/Nb.Notebook" -P date:string=2025-01-01` |
| `fab job run-list` | List executions | `fab job run-list "ws.Workspace/Nb.Notebook"` |
| `fab job run-status` | Check status | `fab job run-status "ws.Workspace/Nb.Notebook" --id <job-id>` |
| **Refreshing Models** |||
| `fab api -A powerbi` | Trigger refresh | `fab api -A powerbi "groups/<ws-id>/datasets/<model-id>/refreshes" -X post -i '{"type":"Full"}'` |
| `fab api -A powerbi` | Check refresh status | `fab api -A powerbi "groups/<ws-id>/datasets/<model-id>/refreshes?\$top=1"` |
| **DAX Queries** |||
| `fab get -q "definition"` | Get model schema first | `fab get "ws.Workspace/Model.SemanticModel" -q "definition"` |
| `fab api -A powerbi` | Execute DAX | `fab api -A powerbi "groups/<ws-id>/datasets/<model-id>/executeQueries" -X post -i '{"queries":[{"query":"EVALUATE..."}]}'` |
| **Lakehouse** |||
| `fab ls` | Browse files/tables | `fab ls "ws.Workspace/LH.Lakehouse/Files"` |
| `fab table schema` | Get table schema | `fab table schema "ws.Workspace/LH.Lakehouse/Tables/sales"` |
| `fab cp` | Upload/download | `fab cp ./local.csv "ws.Workspace/LH.Lakehouse/Files/"` |
| **Access Control** |||
| `fab acl ls` | List permissions | `fab acl ls "ws.Workspace"` |
| `fab acl set` | Set permissions | `fab acl set "ws.Workspace" -I <objectId> -R Member` |
| `fab acl rm` | Remove permissions | `fab acl rm "ws.Workspace" -I <upn>` |
| `fab label set` | Set sensitivity label | `fab label set "ws.Workspace/Nb.Notebook" --name Confidential` |
| **Management** |||
| `fab cp` | Copy items | `fab cp "dev.Workspace/Item.Type" "prod.Workspace" -f` |
| `fab cp -r` | Copy recursively | `fab cp "dev.Workspace" "prod.Workspace" -r -f` |
| `fab mv` | Move/rename items | `fab mv "ws.Workspace/Old.Notebook" "ws.Workspace/New.Notebook"` |
| `fab set` | Update properties | `fab set "ws.Workspace/Item.Type" -q displayName -i "New Name"` |
| `fab rm` | Delete item | `fab rm "ws.Workspace/Item.Type" -f` |
| `fab assign` | Assign capacity/domain | `fab assign .capacities/cap.Capacity -W ws.Workspace` |
| `fab start/stop` | Start/stop resource | `fab start .capacities/cap.Capacity` |

## Core Concepts

### Path Format

Fabric uses filesystem-like paths with type extensions:

`/WorkspaceName.Workspace/ItemName.ItemType`

For lakehouses this is extended into files and tables:

`/WorkspaceName.Workspace/LakehouseName.Lakehouse/Files/FileName.extension` or `/WorkspaceName.Workspace/LakehouseName.Lakehouse/Tables/TableName`

For Fabric capacities you have to use `fab ls .capacities`

Examples:

- `"/Production.Workspace/Sales Model.SemanticModel"`
- `/Data.Workspace/MainLH.Lakehouse/Files/data.csv`
- `/Data.Workspace/MainLH.Lakehouse/Tables/dbo/customers`

### Common Item Types

- `.Workspace` - Workspaces
- `.SemanticModel` - Power BI datasets
- `.Report` - Power BI reports
- `.Notebook` - Fabric notebooks
- `.DataPipeline` - Data pipelines
- `.Lakehouse` / `.Warehouse` - Data stores
- `.SparkJobDefinition` - Spark jobs
- `.AISkill` - AI skills
- `.Eventhouse` / `.Eventstream` - Real-time analytics
- `.MirroredDatabase` / `.MirroredWarehouse` - Mirrored databases
- `.Environment` - Spark environments
- `.SQLDatabase` - SQL databases
- `.UserDataFunction` - User data functions

Full list: 49 types. Use `fab desc .<ItemType>` to check supported commands, or `fab desc all` for all types.

## Essential Commands

For detailed command examples (navigation, resource management, access control, copy/move/export/import, API operations, jobs, tables), see **`references/essential-commands.md`**.

For item-type-specific workflows, see the topic references listed under [References](#references).

## Cross-Workspace Search

### DataHub V2 API (Recommended)

Use `scripts/search_across_workspaces.py` for cross-workspace search with rich metadata not available elsewhere:

```bash
# Find all semantic models (use "Model" not "SemanticModel")
python3 scripts/search_across_workspaces.py --type Model

# Find models by name
python3 scripts/search_across_workspaces.py --type Model --filter "Sales"

# Find stale items (not visited in 6+ months)
python3 scripts/search_across_workspaces.py --type Model --not-visited-since 2024-06-01

# Find items by owner
python3 scripts/search_across_workspaces.py --type PowerBIReport --owner "kurt"

# Find Direct Lake models only
python3 scripts/search_across_workspaces.py --type Model --storage-mode directlake

# Find items in workspace
python3 scripts/search_across_workspaces.py --type Lakehouse --workspace "fit-data"

# Get JSON output
python3 scripts/search_across_workspaces.py --type Model --output json

# Sort by last visited (oldest first)
python3 scripts/search_across_workspaces.py --type Model --sort last-visited --sort-order asc

# List all available types
python3 scripts/search_across_workspaces.py --list-types
```

**Unique DataHub fields** (not available via fab api or admin APIs):

- `lastVisitedTimeUTC` - When item was last opened/used
- `storageMode` - Import, DirectQuery, or DirectLake
- `ownerUser` - Full owner details (name, email)
- `capacitySku` - F2, F64, PP, etc.
- `isDiscoverable` - Whether item appears in search

**Important type mappings:**

- Semantic models: use `--type Model` (not SemanticModel)
- Dataflows: use `--type DataFlow` (capital F)
- Notebooks: use `--type SynapseNotebook`

### Admin APIs (Requires Admin Role)

If you have Fabric/Power BI admin access:

```bash
# Find semantic models by name (cross-workspace)
fab api "admin/items" -P "type=SemanticModel" -q "itemEntities[?contains(name, 'Sales')]"

# Find all notebooks
fab api "admin/items" -P "type=Notebook" -q "itemEntities[].{name:name,workspace:workspaceId}"

# Find all lakehouses
fab api "admin/items" -P "type=Lakehouse"

# Common types: SemanticModel, Report, Notebook, Lakehouse, Warehouse, DataPipeline, Ontology
```

For full admin API reference: [admin.md](./references/admin.md)

## Key Patterns

### JMESPath Queries

Filter and transform JSON responses with `-q`:

```bash
# Get single field
-q "id"
-q "displayName"

# Get nested field
-q "properties.sqlEndpointProperties"
-q "definition.parts[0]"

# Filter arrays
-q "value[?type=='Lakehouse']"
-q "value[?contains(name, 'prod')]"

# Get first element
-q "value[0]"
-q "definition.parts[?path=='model.tmdl'] | [0]"
```

### Error Handling & Debugging

```bash
# Show response headers
fab api workspaces --show_headers

# Verbose output
fab get "Production.Workspace/Item" -v

# Save responses for debugging
fab api workspaces -o /tmp/workspaces.json
```

### Performance Optimization

1. **Use `ls` for fast listing** - Much faster than `get`
2. **Use `exists` before operations** - Check before get/modify
3. **Filter with `-q`** - Get only what you need
4. **Use GUIDs in automation** - More stable than names

## Common Flags

- `-f, --force` - Skip confirmation prompts (also skips sensitivity label on export/get/cp)
- `-v, --verbose` - Verbose output
- `-l` - Long format listing
- `-a` - Show hidden items
- `-r, --recursive` - Recursive copy/move (workspaces and folders)
- `-o, --output` - Output file path
- `-i, --input` - Input file or JSON string
- `-q, --query` - JMESPath query (works on `ls`, `get`, `api`, `acl ls`, `acl get`)
- `-P, --params` - Parameters (key=value)
- `-W, --workspace` - Target workspace (for assign/unassign)
- `-I, --identity` - Entra identity (for acl set/rm)
- `-R, --role` - Role to assign (for acl set)
- `-X, --method` - HTTP method (get/post/put/delete/patch)
- `-A, --audience` - API audience (fabric/powerbi/storage/azure)
- `-bpc` - Block on path collision (cp only)
- `--format` - Definition format (export/import)
- `--show_headers` - Show response headers
- `--timeout` - Timeout in seconds
- `--polling_interval` - Job polling interval in seconds
- `-w, --wait` - Wait for completion (job run-cancel)

## Important Notes

- **All examples assume `fab` is installed and authenticated**
- **Paths require proper extensions** (`.Workspace`, `.SemanticModel`, etc.)
- **Quote paths with spaces**: `"My Workspace.Workspace"`
- **Create output directories before export**: `fab export` does not create intermediate directories; `mkdir -p` the output path first or the command fails with `[InvalidPath]`
- **Use `-f` for non-interactive scripts** (skips prompts; on export, also strips sensitivity labels)
- **Semantic model updates**: Use Power BI API (`-A powerbi`) for DAX queries and dataset operations

## Need More Details?

For specific item type help:

```bash
fab desc .<ItemType>
```

For command help:

```bash
fab --help
fab <command> --help
```

## References

**Skill references:**

- [Quick Start Guide](./references/quickstart.md) - Copy-paste examples for getting started
- [Essential Commands](./references/essential-commands.md) - Detailed command examples and common workflows
- [Querying Data](./references/querying-data.md) - Query semantic models and lakehouse tables
- [Semantic Models](./references/semantic-models.md) - TMDL, DAX, refresh, storage mode
- [Reports](./references/reports.md) - Export, import, visuals, fields
- [Paginated Reports](./references/paginated-reports.md) - RDL upload, export-to-file, datasources, parameters
- [Notebooks](./references/notebooks.md) - Job execution, parameters
- [Workspaces](./references/workspaces.md) - Create, manage, permissions
- [Deployment Pipelines](./references/deployment-pipelines.md) - CI/CD, deploy stages, selective deploy, LRO polling
- [Dataflows](./references/dataflows.md) - Gen1 and Gen2, refresh, publish, admin
- [Dashboards](./references/dashboards.md) - Tiles, clone (dashboards are not reports)
- [Org Apps](./references/org-apps.md) - Read-only API for distributed content packages
- [Scorecards](./references/scorecards.md) - Goals, check-ins, status rules (Preview API)
- [Gateways](./references/gateways.md) - Datasources, credentials, dataset binding
- [Folders](./references/folders.md) - Organize items into folders via API
- [fab vs az CLI](./references/fab-vs-az-cli.md) - When to use which; capacity, networking, Key Vault, monitoring, CMK, CI/CD
- [Admin APIs](./references/admin.md) - Cross-workspace search, tenant operations, governance
- [API Reference](./references/fab-api.md) - Capacities, domains, misc API patterns
- [Full Command Reference](./references/reference.md) - All commands detailed

**External references** (request markdown when possible):

- fab CLI: [GitHub Source](https://github.com/microsoft/fabric-cli) | [Docs](https://microsoft.github.io/fabric-cli/)
- Microsoft: [Fabric CLI Learn](https://learn.microsoft.com/en-us/rest/api/fabric/articles/fabric-command-line-interface)
- APIs: [Fabric API](https://learn.microsoft.com/en-us/rest/api/fabric/articles/) | [Power BI API](https://learn.microsoft.com/en-us/rest/api/power-bi/)
- DAX: [dax.guide](https://dax.guide/) - use `dax.guide/<function>/` e.g. `dax.guide/addcolumns/`
- Power Query: [powerquery.guide](https://powerquery.guide/) - use `powerquery.guide/function/<function>`
- [Power Query Best Practices](https://learn.microsoft.com/en-us/power-query/best-practices)
Comments 0
Latest | Hot
Please login before commenting.
No comments yet. Be the first one!
fabric-cli

Directory Structure

SKILL.md

Report

Notice
