Skill UI

This advanced helper assists users in writing, debugging, and validating complex formulas, pivot tables, and array functions for platforms like Excel and Google Sheets. It ensures formulas are robust by handling common edge cases (e.g., blank rows, mixed data types, time zone quirks) and provides detailed, worked examples. It also manages cross-platform dialect translation.

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.

Provides comprehensive skills and references for writing, debugging, and optimizing DAX within semantic models. It guides users through systematic performance tuning using a tiered framework, covering engine internals, best practices, and profiling techniques for both local and remote models.

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.

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.

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.

A comprehensive guide and toolset for managing the entire lifecycle of semantic models (Power BI/Analysis Services). Use this skill for designing star schemas, building measures, optimizing performance, setting up incremental refreshes, and auditing models against best practices, all driven through the terminal CLI.

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 to the Tabular Editor 2 command-line interface (CLI). It provides essential syntax and usage examples for automating data model management. Key functions include deploying models to XMLA endpoints, executing inline C# scripts, running Best Practice Analyzer (BPA), validating schemas, and integrating model processes into CI/CD pipelines in Windows environments.