Skill UI

This skill provides expert guidance on writing and executing C# scripts to deeply manipulate Power BI semantic models. It allows users to perform bulk operations, manage security roles (RLS/OLS), format DAX expressions, and query model metadata via the TOM API, supporting both Tabular Editor 2 and 3 environments for advanced data engineering tasks.

This skill provides a comprehensive, step-by-step workflow for generating complete Power BI reports from scratch. It guides the user through model discovery, KPI selection, page layout, visual placement, data binding, and publishing, offering rich control over the entire reporting lifecycle using the pbir command-line interface.

This comprehensive guide provides advanced skills and references for writing, debugging, and systematically optimizing DAX in semantic models. It covers deep architectural topics, including engine internals, multi-tiered optimization workflows, and best practices for performance profiling. Use it to troubleshoot slow queries and ensure robust data model performance across Power BI Desktop and Fabric Service.

Deneb is a certified custom visual for Power BI, enabling users to embed and author complex, declarative data visualizations using Vega and Vega-Lite specifications. This skill guides the entire PBIR workflow, covering spec writing, data binding rules, complex JSON injection (including escaping), and validation, allowing for advanced control beyond standard Power BI charts.

A comprehensive guide and reference for using the Fabric Command Line Interface (`fab`) to programmatically manage all aspects of Fabric and Power BI service workspaces, items, and configurations. Covers authentication, searching, data querying, permission management, and advanced deployment workflows.

This skill traces downstream dependencies from a core semantic model to all connected reports and assets across multiple Fabric workspaces. It is essential for impact analysis before making structural changes, auditing data flow, or mapping cross-workspace report connections. Use it to identify which reports rely on a specific dataset, ensuring minimal disruption during development or maintenance.

This skill guides the design, audit, and enforcement of Power BI report themes. It addresses 'formatting debt' by pushing visual styles (colors, fonts, borders) from individual visual JSON files into the global theme definition. This ensures report consistency, simplifies maintenance, and maintains clean, lean visual JSONs, crucial for large and complex data reports.

This guide details the principles of observability, teaching developers how to instrument code by implementing structured logging, metrics, and distributed tracing. It ensures that production features emit sufficient telemetry to answer complex operational questions, transforming unknown failures into diagnosable events. Essential for any service running in production.

Provides comprehensive guidelines and best practices for designing professional and effective Power BI reports. It covers visual hierarchy, page layout, color usage, typography, and adherence to established standards like the 3-30-300 Rule, ensuring reports are clear, efficient, and minimize user cognitive load.

This skill provides expert, developer-level guidance on the Power BI Project (PBIP) file format. PBIP deconstructs the opaque PBIX binary into human-readable, structured text files, enabling robust source control, external editing, and multi-author collaboration. It covers project structure, the difference between thick and thin reports, file conversion (PBIX to PBIP), and critical cross-cutting concerns like rename cascades and data location discrepancies across various report components.

This skill acts as a comprehensive technical reference guide for the Power BI Enhanced Report (PBIR) JSON format. It meticulously details the complex internal schemas, patterns, and hierarchical rules governing report components, including `visual.json`, theme inheritance, field references, and report structure. It is essential for advanced developers who need to read, interpret, and generate valid PBIR metadata for deep report customization.

This comprehensive guide covers the entire lifecycle of Power Query M expressions within semantic models. Learn how to author correct M code, optimize performance using query folding techniques, validate syntax, and test expressions against live data sources. It provides best practices for data filtering, type handling, and building robust, efficient data pipelines.