Fabric Cli Core

# fabric-cli-core

Core skill for Microsoft Fabric CLI operations. **Load this skill first** for any Fabric CLI task.

## What This Skill Provides

- Fabric hierarchy mental model (Tenant → Workspace → Folder → Item → OneLakeItem)
- Path conventions with dot entity suffixes (e.g., `.Workspace`, `.Notebook`)
- Authentication patterns (interactive, SPN, managed identity)
- Hidden entity discovery (`ls -a`)
- Security and sensitive data handling rules
- Critical operational rules
- Common item types reference

## Entry Point

Load [`SKILL.md`](./SKILL.md) to activate this skill.

## References

Detailed documentation in the `references/` folder:

| Reference | Description |
|-----------|-------------|
| [quickstart.md](./references/quickstart.md) | Copy-paste examples for common tasks |
| [reference.md](./references/reference.md) | All commands with flags and patterns |
| [semantic-models.md](./references/semantic-models.md) | TMDL, DAX queries, refresh, storage modes |
| [notebooks.md](./references/notebooks.md) | Job execution, parameters, scheduling |
| [reports.md](./references/reports.md) | Export, import, rebind to models |
| [workspaces.md](./references/workspaces.md) | Create, manage, permissions |
| [querying-data.md](./references/querying-data.md) | DAX and lakehouse table queries |
| [fab-api.md](./references/fab-api.md) | Direct REST API access patterns |
| [create-workspaces.md](./references/create-workspaces.md) | Workspace creation workflows |


# Creating Workspaces

## Create Workspace with Large Storage Format

**Step 1:** List available capacities

```bash
fab ls .capacities
```

**Step 2:** Create workspace on chosen capacity

```bash
fab mkdir "Workspace Name.Workspace" -P capacityName="MyCapacity"
```

**Step 3:** Get workspace ID

```bash
fab get "Workspace Name.Workspace" -q "id"
```

**Step 4:** Set default storage format to Large

```bash
fab api -A powerbi -X patch "groups/<workspace-id>" -i '{"defaultDatasetStorageFormat":"Large"}'
```

Done. The workspace now defaults to Large storage format for all new semantic models.


# Fabric API Reference

Direct API access via `fab api` for operations beyond standard commands.

## API Basics

```bash
# Fabric API (default)
fab api "<endpoint>"

# Power BI API
fab api -A powerbi "<endpoint>"

# With query
fab api "<endpoint>" -q "value[0].id"

# POST with body
fab api -X post "<endpoint>" -i '{"key":"value"}'
```

## Capacities

```bash
# List all capacities
fab api capacities

# Response includes: id, displayName, sku (F2, F64, FT1, PP3), region, state
```

**Pause capacity** (cost savings):

```bash
# CAUTION: Pausing stops all workloads on that capacity
# Resume is intentionally NOT documented - too dangerous for automation
# Use Azure Portal for resume operations

# To pause via Azure CLI (not fab):
az resource update --ids "/subscriptions/{sub}/resourceGroups/{rg}/providers/Microsoft.Fabric/capacities/{name}" \
  --set properties.state=Paused
```

## Gateways

```bash
# List gateways
fab api -A powerbi gateways

# Get gateway datasources
GATEWAY_ID="<gateway-id>"
fab api -A powerbi "gateways/$GATEWAY_ID/datasources"

# Get gateway users
fab api -A powerbi "gateways/$GATEWAY_ID/users"
```

## Deployment Pipelines

```bash
# List pipelines (user)
fab api -A powerbi pipelines

# List pipelines (admin - all tenant)
fab api -A powerbi admin/pipelines

# Get pipeline stages
PIPELINE_ID="<pipeline-id>"
fab api -A powerbi "pipelines/$PIPELINE_ID/stages"

# Get pipeline operations
fab api -A powerbi "pipelines/$PIPELINE_ID/operations"
```

**Deploy content** (use Fabric API):

```bash
# Assign workspace to stage
fab api -X post "deploymentPipelines/$PIPELINE_ID/stages/$STAGE_ID/assignWorkspace" \
  -i '{"workspaceId":"<workspace-id>"}'

# Deploy to next stage
fab api -X post "deploymentPipelines/$PIPELINE_ID/deploy" -i '{
  "sourceStageOrder": 0,
  "targetStageOrder": 1,
  "options": {"allowCreateArtifact": true, "allowOverwriteArtifact": true}
}'
```

## Domains

`