gh-data-goblin-fabric-cli-plugin-fabric-cli-plugin/skills/fabric-cli/references/reports.md

# Report Operations

## Get Report Info

```bash
# Check exists
fab exists "ws.Workspace/Report.Report"

# Get properties
fab get "ws.Workspace/Report.Report"

# Get ID
fab get "ws.Workspace/Report.Report" -q "id"
```

## Get Report Definition

```bash
# Full definition
fab get "ws.Workspace/Report.Report" -q "definition"

# Save to file
fab get "ws.Workspace/Report.Report" -q "definition" -o /tmp/report-def.json

# Specific parts
fab get "ws.Workspace/Report.Report" -q "definition.parts[?path=='definition/report.json'].payload | [0]"
```

## Get Connected Model

```bash
# Get model reference from definition.pbir
fab get "ws.Workspace/Report.Report" -q "definition.parts[?contains(path, 'definition.pbir')].payload | [0]"
```

Output shows `byConnection.connectionString` with `semanticmodelid`.

## Export Report

1. Export to local directory:

```bash
fab export "ws.Workspace/Report.Report" -o /tmp/exports -f
```

2. Creates structure:

```
Report.Report/
├── .platform
├── definition.pbir
└── definition/
    ├── report.json
    ├── version.json
    └── pages/
        └── {page-id}/
            ├── page.json
            └── visuals/{visual-id}/visual.json
```

## Import Report

1. Import from local PBIP:

```bash
fab import "ws.Workspace/Report.Report" -i /tmp/exports/Report.Report -f
```

2. Import with new name:

```bash
fab import "ws.Workspace/NewName.Report" -i /tmp/exports/Report.Report -f
```

## Copy Report Between Workspaces

```bash
fab cp "dev.Workspace/Report.Report" "prod.Workspace" -f
```

## Create Blank Report

1. Get model ID:

```bash
fab get "ws.Workspace/Model.SemanticModel" -q "id"
```

2. Create report via API:

```bash
WS_ID=$(fab get "ws.Workspace" -q "id" | tr -d '"')
fab api -X post "workspaces/$WS_ID/reports" -i '{
  "displayName": "New Report",
  "datasetId": "<model-id>"
}'
```

## Update Report Properties

```bash
# Rename
fab set "ws.Workspace/Report.Report" -q displayName -i "New Name"

# Update description
fab set "ws.Workspace/Report.Report" -q description -i "Description text"
```

## Rebind to Different Model

1. Get new model ID:

```bash
fab get "ws.Workspace/NewModel.SemanticModel" -q "id"
```

2. Rebind:

```bash
fab set "ws.Workspace/Report.Report" -q semanticModelId -i "<new-model-id>"
```

## Delete Report

```bash
fab rm "ws.Workspace/Report.Report" -f
```

## List Pages

```bash
fab get "ws.Workspace/Report.Report" -q "definition.parts[?contains(path, 'page.json')].path"
```

## List Visuals

```bash
fab get "ws.Workspace/Report.Report" -q "definition.parts[?contains(path, '/visuals/')].path"
```

## Count Visuals by Type

1. Export visuals:

```bash
fab get "ws.Workspace/Report.Report" -q "definition.parts[?contains(path,'/visuals/')]" > /tmp/visuals.json
```

2. Count by type:

```bash
jq -r '.[] | .payload.visual.visualType' < /tmp/visuals.json | sort | uniq -c | sort -rn
```

## Extract Fields Used in Report

1. Export visuals (if not done):

```bash
fab get "ws.Workspace/Report.Report" -q "definition.parts[?contains(path,'/visuals/')]" > /tmp/visuals.json
```

2. List unique fields:

```bash
jq -r '[.[] | (.payload.visual.query.queryState // {} | to_entries[] | .value.projections[]? | if .field.Column then "\(.field.Column.Expression.SourceRef.Entity).\(.field.Column.Property)" elif .field.Measure then "\(.field.Measure.Expression.SourceRef.Entity).\(.field.Measure.Property)" else empty end)] | unique | sort | .[]' < /tmp/visuals.json
```

## Validate Fields Against Model

1. Export report:

```bash
fab export "ws.Workspace/Report.Report" -o /tmp/report -f
```

2. Extract field references:

```bash
find /tmp/report -name "visual.json" -exec grep -B2 '"Property":' {} \; | \
  grep -E '"Entity":|"Property":' | paste -d' ' - - | \
  sed 's/.*"Entity": "\([^"]*\)".*"Property": "\([^"]*\)".*/\1.\2/' | sort -u
```

3. Compare against model definition to find missing fields.

## Report Permissions

1. Get IDs:

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

2. List users:

```bash
fab api -A powerbi "groups/$WS_ID/reports/$REPORT_ID/users"
```

3. Add user:

```bash
fab api -A powerbi "groups/$WS_ID/reports/$REPORT_ID/users" -X post -i '{
  "emailAddress": "user@domain.com",
  "reportUserAccessRight": "View"
}'
```

## Deploy Report (Dev to Prod)

1. Export from dev:

```bash
fab export "dev.Workspace/Report.Report" -o /tmp/deploy -f
```

2. Import to prod:

```bash
fab import "prod.Workspace/Report.Report" -i /tmp/deploy/Report.Report -f
```

3. Verify:

```bash
fab exists "prod.Workspace/Report.Report"
```

## Clone Report with Different Model

1. Export source:

```bash
fab export "ws.Workspace/Template.Report" -o /tmp/clone -f
```

2. Edit `/tmp/clone/Template.Report/definition.pbir` to update `semanticmodelid`

3. Import as new report:

```bash
fab import "ws.Workspace/NewReport.Report" -i /tmp/clone/Template.Report -f
```

## Troubleshooting

### Report Not Found

```bash
fab exists "ws.Workspace"
fab ls "ws.Workspace" | grep -i report
```

### Model Binding Issues

```bash
# Check current binding
fab get "ws.Workspace/Report.Report" -q "definition.parts[?contains(path, 'definition.pbir')].payload | [0]"

# Rebind
fab set "ws.Workspace/Report.Report" -q semanticModelId -i "<model-id>"
```

### Import Fails

```bash
# Verify structure
ls -R /tmp/exports/Report.Report/

# Check definition is valid JSON
fab get "ws.Workspace/Report.Report" -q "definition" | jq . > /dev/null && echo "Valid"
```