Skill UI

An interactive skill designed to guide users through the process of generating, auditing, and improving Best Practice Analyzer (BPA) rules for Power BI semantic models. It follows a double-diamond discovery process, first gathering deep organizational context and model details, and then recommending tailored rules for validation, governance, and compliance.

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.

Expert guidance for connecting to Power BI Desktop's local tabular model. It utilizes the Tabular Object Model (TOM) and ADOMD.NET via PowerShell to perform advanced operations such as model enumeration, running complex DAX queries, modifying metadata, defining field parameters, and querying the local Analysis Services instance. This skill is critical for model development when remote connectivity is unavailable.

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.

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.

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.

A comprehensive command-line interface (CLI) for the full lifecycle management of Power BI reports. This tool enables users to explore, create, format, validate, and publish reports using programmatic commands, supporting both Power BI Desktop integration and seamless publishing to Fabric. It is essential for automating report generation and ensuring data model integrity.

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 provides expert guidance on Public Relations (PR) and maximizing earned media for software products. It teaches the philosophy of successful pitching, focusing on identifying strong stories (trends, data, human narrative) rather than just the product. Learn four modes of outreach—reactive newsjacking, proactive pitching, inbound requests, and owned assets—to build brand legitimacy, backlinks, and industry authority from journalists and publications.