fabric-cli-powerbi

Malicious tool definition detected

## When to Load Load this skill when: - Working with semantic models (datasets) — refresh, DAX, TMDL - Managing Power BI reports — export, rebind, clone - Querying data via DAX - Managing gateways and data sources - Troubleshooting refresh failures ## Prerequisites - Load `fabric-cli-core` skill first - User authenticated via `fab auth login` - Access to workspace containing Power BI items ## Contents

Malicious tool definition detected

Tool: SKILL.md [1/2] Description: --- name: fabric-cli-powerbi description: Use Fabric CLI for Power BI operations — semantic models, reports, DAX queries, refresh, gateways.

Tool: SKILL.md [2/2] Description: Ownership When a semantic model owner leaves the organization: ```bash WS_ID=$(fab get "ws.Workspace" -q "id" | tr -d '"') MODEL_ID=$(fab get "ws.Workspace/Model.SemanticModel" -q "id" | tr -d '"') # Take over semantic model ownership fab api -A powerbi "groups/$WS_ID/datasets/$MODEL_ID/Default.TakeOver" -X post ``` ## 8 - Common Patterns ### Dev to Production Deployment ```bash #!/bin/bash DEV_WS="Dev.Workspace" PROD_WS="Prod.Workspace" # 1.

Malicious tool definition detected

## Prerequisites ```bash # Get model ID MODEL_ID=$(fab get "ws.Workspace/Model.SemanticModel" -q "id" | tr -d '"') ``` ## Basic Queries ### Simple EVALUATE ```bash fab api -A powerbi "datasets/$MODEL_ID/executeQueries" -X post -i '{ "queries": [{"query": "EVALUATE VALUES(Date[Year])"}] }' ``` ### Table Preview ```bash fab api -A powerbi "datasets/$MODEL_ID/executeQueries" -X post -i '{ "queries": [{"query": "EVALUATE TOPN(100, Sales)"}] }' ``` ### Multiple Queries ```bash fab api -A powerbi "dat

Malicious tool definition detected

```bash # List all gateways (requires admin or gateway permissions) fab ls .gateways # List with details fab ls .gateways -v ``` ## Get Gateway Info ```bash # Get gateway by name fab get ".gateways/MyGateway.Gateway" # Get gateway ID GATEWAY_ID=$(fab get ".gateways/MyGateway.Gateway" -q "id" | tr -d '"') # Get gateway via API fab api -A powerbi "gateways/$GATEWAY_ID" ``` ## Gateway Cluster Status ```bash # Check gateway cluster members fab api -A powerbi "gateways/$GATEWAY_ID" -q "gatewayAnnotat

Malicious tool definition detected

Tool: references/refresh.md Description: # Refresh Operations Comprehensive guide for managing semantic model refresh operations using Fabric CLI.

Malicious tool definition detected

Tool: references/reports.md Description: # Reports Reference Working with Power BI reports via Fabric CLI.

Malicious tool definition detected

## Item Type Use `.SemanticModel` suffix when referencing semantic models: ```bash # Reference format ws.Workspace/ModelName.SemanticModel ``` ## List Semantic Models ```bash # List in current workspace fab ls .

Malicious tool definition detected

Tool: scripts/list_refresh_history.py [1/2] Description: #!/usr/bin/env python3 """ list_refresh_history.py - Show refresh history and failure details This script displays the refresh history for a semantic model, including duration, status, and error details.

Tool: scripts/list_refresh_history.py [2/2] Description: ) # Print analysis summary if report["analysis"]: analysis = report["analysis"] print(" " + "=" * 50) print("REFRESH ANALYSIS") print("=" * 50) print(f"Total Refreshes: {analysis['total_refreshes']}") print(f" Successful: {analysis['successful']}") print(f" Failed: {analysis['failed']}") print(f" Cancelled: {analysis['cancelled']}") print(f" In Progress: {analysis['in_progress']}") print(f"

Malicious tool definition detected

Tool: scripts/rebind_report.py [1/2] Description: #!/usr/bin/env python3 """ rebind_report.py - Rebind report to different semantic model This script changes the semantic model connection for a Power BI report in Microsoft Fabric.

Description: "model_id": model_id, "previous_model": current_datasource.get("current_model"), "status": "unknown", "message": "" } # Dry run mode if args.dry_run: result["status"] = "dry_run" result["message"] = "Would rebind report to specified model (dry run, no changes made)" print_result(result, args.format, args.output) return 0 # Perform rebind if args.verbose: print("Rebinding report to new model...", file=sys.stderr) rebind_result = rebind_report( report_workspace_id, report_id, model_id

Malicious tool definition detected

Tool: scripts/refresh_model.py [1/2] Description: #!/usr/bin/env python3 """ refresh_model.py - Trigger and monitor semantic model refresh This script triggers a semantic model refresh in Microsoft Fabric and optionally waits for completion with configurable timeout.

Tool: scripts/refresh_model.py [2/2] Description: --wait --json Note: Without --wait, the script triggers the refresh and exits immediately.