Power Query Coaching
Learn Power Query best practices & troubleshoot errors with personalized guidance from thepexcel's AI coaching assistant.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add power-query-coaching npx -- -y @trustedskills/power-query-coaching
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"power-query-coaching": {
"command": "npx",
"args": [
"-y",
"@trustedskills/power-query-coaching"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill provides coaching and guidance on using Power Query, Microsoft's data transformation tool. It can help users write M code, understand error messages, and optimize their queries for better performance. The agent will offer explanations of concepts and suggest improvements to existing Power Query scripts.
When to use it
- You’re struggling with a complex Power Query formula and need assistance debugging or understanding the logic.
- You want to learn how to perform specific data transformations in Power Query, such as merging tables or cleaning text data.
- Your Power Query script is slow, and you'd like suggestions for optimization.
- You’re new to Power Query and need a step-by-step guide to creating your first queries.
Key capabilities
- M code generation assistance
- Error message explanation
- Query optimization suggestions
- Conceptual explanations of Power Query features
Example prompts
- "I'm getting an error 'Expression.Error: We don't know how to transform...' in my Power Query script, can you help me understand what it means?"
- "How do I merge two tables in Power Query based on a common column?"
- "My Power Query query is taking too long to run. Can you suggest ways to optimize it?"
Tips & gotchas
The agent's effectiveness depends on the user providing clear and specific details about their Power Query task or problem. Providing existing M code snippets will yield more targeted assistance.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.