pbi-squire

Automate Power BI project analysis, artifact creation, and deployment with DAX/M edits.

1|Updated Oct 17, 2025
One-click install
npx skills add https://github.com/cn-dataworks/pbi-squire-plugin --skill pbi-squire
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: pbi-squire
Source: https://github.com/cn-dataworks/pbi-squire-plugin/tree/main/skills/pbi-squire
Command: npx skills add https://github.com/cn-dataworks/pbi-squire-plugin --skill pbi-squire

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automates comprehensive Power BI project analysis, artifact creation, and deployment with live model editing when available, and seamless fallback to file-based workflows.

Core Features & Use Cases

  • Diagnose and fix calculation issues in DAX, create new measures, calculated columns, and tables
  • Transform data with Power Query / M code, document dashboards in business terms, and deploy changes with validation gates
  • Merge and compare Power BI projects for version control and collaboration; supports PBIP projects and PBIR generation

Quick Start

Describe your Power BI problem or goal and I will diagnose, design the necessary changes, and validate them automatically.

Frequently Asked Questions about pbi-squire

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate Power BI DAX measure creation and model editing?

Power BI DAX measure creation and model editing can be automated by applying MCP live-model editing to diagnose issues, design new measures, and validate changes with fallback to file-based manipulation.

Can I modify Power Query M code in PBIX files without opening Power BI Desktop?

Yes, you can modify M code in PBIX files without Power BI Desktop by using automated file-based manipulation to transform data, apply changes, and validate through enforced design gates.

What is the best way to compare and merge Power BI projects for version control?

The best way to compare and merge Power BI projects for version control is by automating project analysis to merge artifacts, support PBIP projects, and generate PBIR for collaboration.

Does automated Power BI deployment support data anonymization and calculated tables?

Automated Power BI deployment supports data anonymization alongside creating calculated tables, calculated columns, and measures while applying validation gates to ensure safe modifications.

Why do my Power BI changes fail validation during automated deployment?

Power BI changes fail validation during automated deployment when enforced validation gates detect design standard violations or calculation issues in DAX, requiring versioned backups for safe restoration.