Powerbi Report CLI

az rest --method get \
  --resource "https://api.fabric.microsoft.com" \
  --url "https://api.fabric.microsoft.com/v1/workspaces/$WS_ID/reports" \
  --query "value[].{name:displayName, id:id, description:description}" \
  --output table

az rest --method get \
  --resource "https://api.fabric.microsoft.com" \
  --url "https://api.fabric.microsoft.com/v1/workspaces/$WS_ID/reports/$REPORT_ID"

set -euo pipefail

# Robust file-based flow: save only the final successful PBIR body, then unpack it.
GET_DEF_URL="https://api.fabric.microsoft.com/v1/workspaces/$WS_ID/reports/$REPORT_ID/getDefinition?format=PBIR"

az rest --method post \
  --resource "https://api.fabric.microsoft.com" \
  --url "$GET_DEF_URL" \
  --output-file payload.json \
  --verbose 2>&1 | tee get-definition-start.log

# If the initial 202 response appears, payload.json is not the definition yet.
# Capture the operation ID from verbose headers, poll to Succeeded, then save
# the terminal successful getDefinition body to payload.json before unpacking.
OP_ID=$(grep -ioE "x-ms-operation-id[^a-f0-9-]*[a-f0-9-]+" get-definition-start.log | grep -ioE "[a-f0-9-]+$" | head -1 || true)
if [ -n "$OP_ID" ]; then
  OP_URL="https://api.fabric.microsoft.com/v1/operations/$OP_ID"
  MAX_LRO_ATTEMPTS=60
  LRO_ATTEMPT=1
  RETRY_AFTER=$(grep -ioE "Retry-After[^0-9]*[0-9]+" get-definition-start.log | grep -oE "[0-9]+$" | head -1 || true)
  SLEEP_SECONDS=5
  MAX_SLEEP_SECONDS=30
  if [ -n "$RETRY_AFTER" ]; then
    SLEEP_SECONDS="$RETRY_AFTER"
    [ "$SLEEP_SECONDS" -gt "$MAX_SLEEP_SECONDS" ] && SLEEP_SECONDS="$MAX_SLEEP_SECONDS"
  fi
  while [ "$LRO_ATTEMPT" -le "$MAX_LRO_ATTEMPTS" ]; do
    if ! STATUS=$(az rest --method get \
      --resource "https://api.fabric.microsoft.com" \
      --url "$OP_URL" \
      --query status \
      --output tsv); then
      echo "Failed to poll getDefinition LRO status for operation $OP_ID" >&2
      exit 1
    fi
    case "$STATUS" in
      Succeeded) break ;;
      Failed|Cancelled)
        az rest --method get \
          --resource "https://api.fabric.microsoft.com" \
          --url "$OP_URL"
        exit 1
        ;;
      Running|NotStarted) ;;
      "") echo "Empty getDefinition LRO status for operation $OP_ID" >&2; exit 1 ;;
      *) echo "Unexpected getDefinition LRO status: $STATUS" >&2; exit 1 ;;
    esac
    if [ "$LRO_ATTEMPT" -eq "$MAX_LRO_ATTEMPTS" ]; then
      echo "Timed out waiting for getDefinition LRO operation $OP_ID" >&2
      exit 1
    fi
    # Honor the initial Retry-After header when present; subsequent Retry-After
    # values are not reliably exposed by az rest with --query/--output tsv, so
    # use documented bounded backoff without corrupting status parsing.
    sleep "$SLEEP_SECONDS"
    if [ "$SLEEP_SECONDS" -lt "$MAX_SLEEP_SECONDS" ]; then
      SLEEP_SECONDS=$((SLEEP_SECONDS * 2))
      [ "$SLEEP_SECONDS" -gt "$MAX_SLEEP_SECONDS" ] && SLEEP_SECONDS="$MAX_SLEEP_SECONDS"
    fi
    LRO_ATTEMPT=$((LRO_ATTEMPT + 1))
  done

  az rest --method get \
    --resource "https://api.fabric.microsoft.com" \
    --url "https://api.fabric.microsoft.com/v1/operations/$OP_ID/result" \
    --output-file payload.json \
    --verbose 2>&1 | tee get-definition-result.log
fi

# Only unpack payload.json after it contains either the synchronous 200 body or
# the /operations/$OP_ID/result body from the terminal successful LRO.

powerbi-report-author unpack ./MyReport.Report --input payload.json

printf '%s' "$DEFINITION_JSON" | powerbi-report-author unpack ./MyReport.Report

set -euo pipefail

powerbi-report-author pack ./MyReport.Report --raw --mode create --display-name "My New Report" --description "Created via Fabric API" --out create-report.json

az rest --method post \
  --resource "https://api.fabric.microsoft.com" \
  --url "https://api.fabric.microsoft.com/v1/workspaces/$WS_ID/reports" \
  --headers "Content-Type=application/json" \
  --body @create-report.json \
  --verbose 2>&1 | tee create-report-start.log

set -euo pipefail

powerbi-report-author pack ./MyReport.Report --raw --mode create --display-name "My New Report" --description "Created via Fabric API" | az rest --method post \
  --resource "https://api.fabric.microsoft.com" \
  --url "https://api.fabric.microsoft.com/v1/workspaces/$WS_ID/reports" \
  --headers "Content-Type=application/json" \
  --body @- \
  --verbose 2>&1 | tee create-report-pipe-start.log

[Console]::OutputEncoding = [System.Text.UTF8Encoding]::new()
$OutputEncoding = [System.Text.UTF8Encoding]::new()
# Then, if you intentionally use the pipe form:
powerbi-report-author pack ./MyReport.Report --raw --mode create --display-name "My New Report" --description "Created via Fabric API" | az rest --method post --resource "https://api.fabric.microsoft.com" --url "https://api.fabric.microsoft.com/v1/workspaces/$WS_ID/reports" --headers "Content-Type=application/json" --body "@-" --verbose 2>&1 | Out-File ".\create-report-pipe-start.log" -Encoding utf8

set -euo pipefail

powerbi-report-author pack ./MyReport.Report --raw --out update-definition.json

az rest --method post \
  --resource "https://api.fabric.microsoft.com" \
  --url "https://api.fabric.microsoft.com/v1/workspaces/$WS_ID/reports/$REPORT_ID/updateDefinition" \
  --headers "Content-Type=application/json" \
  --body @update-definition.json \
  --verbose 2>&1 | tee update-definition-start.log

set -euo pipefail

powerbi-report-author pack ./MyReport.Report --raw | az rest --method post \
  --resource "https://api.fabric.microsoft.com" \
  --url "https://api.fabric.microsoft.com/v1/workspaces/$WS_ID/reports/$REPORT_ID/updateDefinition" \
  --headers "Content-Type=application/json" \
  --body @- \
  --verbose 2>&1 | tee update-definition-pipe-start.log

[Console]::OutputEncoding = [System.Text.UTF8Encoding]::new()
$OutputEncoding = [System.Text.UTF8Encoding]::new()
# Then, if you intentionally use the pipe form:
powerbi-report-author pack ./MyReport.Report --raw | az rest --method post --resource "https://api.fabric.microsoft.com" --url "https://api.fabric.microsoft.com/v1/workspaces/$WS_ID/reports/$REPORT_ID/updateDefinition" --headers "Content-Type=application/json" --body "@-" --verbose 2>&1 | Out-File ".\update-definition-pipe-start.log" -Encoding utf8

cat > update-report.json << 'EOF'
{
  "displayName": "Renamed Report",
  "description": "Updated description"
}
EOF

az rest --method patch \
  --resource "https://api.fabric.microsoft.com" \
  --url "https://api.fabric.microsoft.com/v1/workspaces/$WS_ID/reports/$REPORT_ID" \
  --headers "Content-Type=application/json" \
  --body @update-report.json

# Soft delete (recoverable)
az rest --method delete \
  --resource "https://api.fabric.microsoft.com" \
  --url "https://api.fabric.microsoft.com/v1/workspaces/$WS_ID/reports/$REPORT_ID"

# Hard delete (permanent)
az rest --method delete \
  --resource "https://api.fabric.microsoft.com" \
  --url "https://api.fabric.microsoft.com/v1/workspaces/$WS_ID/reports/$REPORT_ID?hardDelete=true"

Report/
├── definition.pbir                              # Semantic model reference (required)
├── definition/
│   ├── report.json                              # Report-level settings (required)
│   ├── version.json                             # Format version (required)
│   ├── pages/
│   │   ├── pages.json                           # Page listing (required)
│   │   ├── <pageId>/
│   │   │   ├── page.json                        # Page layout
│   │   │   ├── visuals/
│   │   │   │   ├── <visualId>/
│   │   │   │   │   ├── visual.json              # Visual config
│   │   │   │   │   ├── mobile.json              # Mobile layout (optional)
│   ├── bookmarks/                               # Bookmarks (optional)
├── StaticResources/                             # Custom themes, images (optional)

{
  "$schema": "https://developer.microsoft.com/json-schemas/fabric/item/report/definitionProperties/2.0.0/schema.json",
  "version": "4.0",
  "datasetReference": {
    "byConnection": {
      "connectionString": "semanticmodelid=<SemanticModelId>"
    }
  }
}