Skill UI

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 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.

This skill guides the creation of advanced, publication-quality statistical visualizations within Power BI using the R programming language, primarily leveraging the ggplot2 package. It details the entire workflow, from structuring the visual JSON (using `pbir-format`) to writing the mandatory `ggplot2` script and correctly injecting it into the report. Ideal for data scientists needing to render complex, customized charts that surpass standard Power BI visuals. Static PNG output is generated, ensuring high fidelity for reports.

This guide provides a comprehensive workflow for managing the refresh lifecycle of semantic models and datasets in Power BI/Fabric. It details how to use the enhanced REST API and Fabric CLI to trigger specific refresh types (e.g., full, dataOnly, calculate), validate data baselines, monitor status, and handle post-refresh validation, ensuring data integrity and proper pipeline orchestration.