Skill UI

Provides expert guidance for connecting to a local Power BI Desktop tabular model using PowerShell's Tabular Object Model (TOM) and ADOMD.NET. This skill enables model enumeration, executing complex DAX queries, modifying metadata (fields, measures, parameters), and managing the report canvas state via the Desktop Bridge. It is critical for direct model interaction when external CLIs are unavailable.

This skill provides a comprehensive, step-by-step workflow for generating complete Power BI reports from scratch using the pbir CLI. It covers everything from initial model discovery and defining design briefs to visual placement, formatting, filtering, validation, and final publishing in Fabric or Power BI Desktop. It ensures best practices are followed to create robust, professional, and interactive dashboards.

A comprehensive guide and tooling set for developing advanced custom visualizations in Power BI (PBIR) using Deneb. This skill guides users through authoring Vega and Vega-Lite specifications, handling complex JSON injection, data binding, and ensuring proper integration within Power BI reports. It is crucial for creating highly interactive and advanced BI dashboards.

This skill provides tools to audit, enforce, and standardize Power BI report themes. It addresses 'formatting debt' by centralizing bespoke visual overrides into the theme JSON, ensuring global consistency. Use it when reports suffer from formatting inconsistency, or when manual visual formatting has cluttered the visual JSON, allowing developers to maintain a clean, scalable report structure.

Comprehensive guidelines covering best practices for Power BI report development. This includes establishing a consistent design identity, applying visual hierarchy rules (like the 3-30-300 rule), managing color discipline, ensuring accessibility, and structuring pages based on their intended question or purpose. It helps transform raw data into professional, actionable, and user-friendly reports.

Details the PBIP (Power BI Project) format, which converts the opaque PBIX binary into a clear, structured, and editable set of text files. This guide covers project structure, cross-cutting operations (like renaming and forking), and the technical differences between Thick and Thin reports, enabling better Git integration and multi-author collaboration.

A comprehensive guide for authors and developers on managing, writing, and validating Power Query M expressions within semantic model partitions. Covers critical concepts such as Query Folding for performance optimization, best practices for filtering and type handling, and advanced techniques for testing M code using the Power Query API.

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.

This guide details how to integrate R code, primarily using the powerful ggplot2 library, into Power BI reports. It enables the creation of advanced, static, and publication-quality statistical visualizations. The process covers the technical workflow, including setting up the JSON structure, writing the mandatory R script (e.g., using `print(p)`), handling data injection, and adhering to best practices for professional BI reporting.

This comprehensive guide details the programmatic management of semantic model refreshes using the Power BI Enhanced Refresh REST API and Fabric CLI. It covers the entire refresh lifecycle, including resolving model IDs, validating baseline data, triggering various refresh types (full, data-only, calculate), monitoring status, and performing robust post-refresh validation. Essential for automating ETL and data pipeline processes in a modern data platform.

Provides a structured, actionable review of Power BI reports across their entire lifecycle—from development to active use. The tool assesses report effectiveness, usage adoption, data performance (load times), and structural integrity. It generates a prioritized list of findings and concrete recommendations, helping users determine if reports are worth maintaining, optimizing, or retiring.

A comprehensive guide for managing the entire lifecycle of tabular data models (Semantic Models) in Power BI/Analysis Services. It provides best practices and a tool cascade (CLI, TOM, TMDL) for designing, building, optimizing, refreshing, and auditing models. Use this skill when performing advanced model operations, optimizing performance, or ensuring data quality.