Skill UI

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 reference for the Power BI Enhanced Report (PBIR) JSON format. This skill details the structure of report metadata, including visual configurations (visual.json), report-level settings, theme inheritance, and complex formatting rules. It is essential for developers needing to read, interpret, or programmatically interact with the internal workings and schema of Power BI reports.

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.

A comprehensive guide and set of tools for embedding dynamic Python visualizations (using matplotlib and seaborn) into Power BI reports. It details the structured workflow, including script injection, data handling (dataset DataFrame), and mandatory best practices for generating static PNG output. Ideal for advanced data analysis and complex reporting.

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.

An interactive workflow designed to audit and standardize naming conventions within Power BI semantic models stored as TMDL files. It ensures that tables, columns, measures, and display folders adhere to consistent, human-readable, and business-aligned standards. The tool guides users through gathering critical business context before auditing and applying complex, cross-file reference updates to maintain data integrity.

This skill enables the generation of rich, inline SVG graphics directly within Power BI reports. By writing DAX measures that return SVG markup strings and setting the data category to ImageUrl, users can visualize complex charts (like sparklines, gauges, and progress bars) within standard visuals such as Tables, Cards, and Matrices. It guides users through the entire process, including recommended best practices like using existing UDF libraries and adhering to strict VAR-based DAX structures.

A comprehensive guide for searching documentation across multiple BI sources (TE docs, DAX.guide, SQLBI, Power BI/Fabric) using the pbi-search CLI. It also details the structure and use of critical configuration files, such as .tmuo, Preferences.json, and UiPreferences.json, essential for advanced data modeling and deployment.