Skill UI

Helps implement optimized Power BI semantic models by analyzing the active model with MCP tools, then advising on star schemas, DAX, relationships, security, documentation, and performance best practices for reporting scenarios.

Provides a systematic guide for diagnosing and improving poor search quality in vector databases like Qdrant. This guide covers troubleshooting issues such as low recall, when approximate search degrades, selecting optimal embedding models, and correctly tuning HNSW parameters, quantization, and filtering strategies. Essential for optimizing RAG and semantic search pipelines.

This skill provides expert, guided assistance for creating, auditing, and improving Best Practice Analyzer (BPA) rules for Power BI semantic models. It utilizes an interactive, double-diamond discovery process to gather deep context about your organizational standards, model structure, and business goals before generating tailored, reusable data validation and governance rules.

This tool analyzes and maps the downstream dependencies of a semantic model across multiple Fabric workspaces. It is crucial for performing impact assessments before making modifications, auditing connected reports, or mapping cross-workspace data flows. It automates the lineage discovery process, providing comprehensive visibility into which reports rely on a specific data source.

A comprehensive CLI tool (pbir) designed for managing the entire lifecycle of Power BI reports. It allows users to explore, build, format, validate, and publish reports using structured commands, simulating the object model. It supports direct interaction with .pbix files, querying semantic models, and integrating with Power BI Desktop for visual verification, enforcing an iterative, structured workflow.

A comprehensive guide to authoring, optimizing, and validating Power Query M expressions used within semantic model partitions. This resource covers crucial topics such as maintaining query folding for performance, applying early filtering and column pruning, and leveraging the Power Query API for robust data validation and debugging.

A comprehensive guide and API wrapper for triggering, monitoring, and validating semantic model refreshes in Power BI/Fabric. It supports various refresh types (full, data-only, calculate-only, etc.), enabling granular control over data reloading, recalculation, and performance troubleshooting using the Fabric CLI and Enhanced Refresh API.

Provides comprehensive guidance for the full lifecycle management of semantic models (e.g., Power BI/Analysis Services). Use this skill when designing, building, optimizing, refreshing, or auditing data models. It guides the user through best practices, relationship management, measure creation, and model optimization (e.g., size reduction, Direct Lake setup), ensuring changes are routed through the most appropriate tool cascade (te CLI, TOM, or TMDL authoring).

An interactive workflow for auditing and standardizing naming conventions (tables, columns, measures) in Power BI semantic models (TMDL). It ensures names are human-readable, consistent, and aligned with core business terminology, addressing technical issues like abbreviations, mixed casing, and inappropriate technical prefixes.

The Tabular Editor CLI (`te`) is a cross-platform, command-line utility for managing the entire lifecycle of semantic models (TMDL/BIM). It allows users to scaffold, inspect, validate, deploy, refresh, test, and query data models against various services, including Power BI, Fabric, and Azure AS, directly from the terminal. Ideal for automated workflows and CI/CD pipelines.