ag-pq-auditor

What problem does it solve?

Un-audited Power Query pipelines in Excel workbooks often hide performance bottlenecks, data quality errors, security vulnerabilities like embedded credentials, and hard-to-debug architecture issues that slow down refresh times and produce unreliable analytics.

Core Features & Use Cases

• Comprehensive Rule-Based Auditing: Checks for query folding breaks, hardcoded file paths, missing error handling, circular dependencies, auto-generated step names, and 15+ other common Power Query issues.
• Multiple Input Support: Audits M code directly from Excel workbooks (via Windows COM automation) or loose .m files, with a built-in demo mode for testing.
• Actionable Findings: Returns severity-rated issues with clear remediation guidance, aligned with standard Power Query best practices.
• Use Case: A data analyst struggling with a 10-minute Power Query refresh can use this skill to identify the root cause (e.g., mid-query Table.Buffer calls, unfiltered wide sources) and fix it in minutes.

Quick Start

Use the ag-pq-auditor skill to audit the Power Query M code in your Excel workbook or folder of .m files for performance, security, and data quality issues.