power-bi
This skill guides you through complete Power BI projects using the PBIP format—a git-friendly, text-based structure for version control. Work with TMDL semantic models, Power Query expressions, DAX measures, and star schema relationships, then publish to Power BI Service with scheduled refresh and gateway configuration.
Power BI skill builds end-to-end projects in PBIP format with TMDL models, Power Query, and DAX.
AI-generated summary based on this skill's SKILL.md
Install
julianobarbosa/claude-code-skills/power-bi · repository language: Python
git clone https://github.com/julianobarbosa/claude-code-skills
cp -r claude-code-skills/skills/power-bi ~/.claude/skills/power-biFrequently asked questions
AI-generated answers based on this skill's SKILL.md and metadata
What is power bi development pbip format and why use it?
Power BI's PBIP format is a git-friendly, text-based project structure that replaces the binary PBIX format. The power-bi skill guides you through complete PBIP projects, enabling version control, collaborative development, and easier code review. PBIP stores semantic models in TMDL (Tabular Model Definition Language), Power Query expressions, and report definitions as separate text files—ideal for teams using git workflows.
How do I create and work with TMDL semantic models in power-bi?
The power-bi skill teaches you to build semantic models using TMDL, the text-based format for Tabular models. You'll design star schema relationships, configure tables and columns, and define DAX measures directly in readable text files. TMDL models integrate seamlessly with PBIP projects, allowing you to edit model logic in your preferred editor and track changes through git.
How can I debug power query m language expressions?
Power BI's Power Query editor lets you step through M expressions, inspect intermediate results, and validate transformations. The power-bi skill covers writing and debugging Power Query expressions for semantic models, including folder-based CSV imports, connector configuration, and error handling. Use the formula bar and query diagnostics to trace logic and resolve data transformation issues.
What are best practices for dax measures and power bi authoring?
The power-bi skill guides you through writing and debugging DAX measures for semantic models, covering calculation logic, context transitions, and performance optimization. Best practices include using meaningful measure names, leveraging CALCULATE for context modification, and testing measures with sample data. Organize measures logically within tables and document complex formulas for maintainability.
How do I publish power bi reports and set up scheduled refresh?
The power-bi skill covers the full publishing workflow: design your PBIP project locally, push to Power BI Service, configure data gateways for on-premises sources, and enable scheduled refresh. You'll learn authentication setup, connector troubleshooting for Azure and enterprise connectors, and monitoring refresh failures to ensure reliable data delivery.
How does pbip project structure support git version control?
Power BI's PBIP format stores projects as text-based files—TMDL models, Power Query definitions, report layouts, and metadata—making them ideal for git. The power-bi skill teaches you to manage version-controlled PBIP projects, track changes across team members, perform code reviews, and resolve merge conflicts. This approach replaces binary PBIX files with collaborative, auditable development practices.
SKILL.md
rendered from the published skill — quoted content, verbatim
Power BI Development Skill
End-to-end Power BI project development using the PBIP (Power BI Project) format — the git-friendly, text-based format for version-controlled Power BI solutions.
When This Skill Applies
- Creating or modifying Power BI semantic models (TMDL files)
- Writing or debugging Power Query (M) expressions (.pq files)
- Authoring DAX measures
- Designing star schema data models
- Publishing reports to Power BI Service
- Configuring scheduled refresh and data gateways
-
Troubleshooting PBI connectors (especially Azure Cost Management / EA)
(truncated - see the full file via the links below)
Read as markdown · JSON record · Browse the source repository
File tree — 15 files
skills/power-bi/SKILL.md
skills/power-bi/evals/evals.json
skills/power-bi/powerbi-skill-workspace/iteration-1/eval-1-dax-measure/with_skill/outputs/custo-rg-pct.tmdl
skills/power-bi/powerbi-skill-workspace/iteration-1/eval-1-dax-measure/with_skill/timing.json
skills/power-bi/powerbi-skill-workspace/iteration-1/eval-1-dax-measure/without_skill/outputs/custo-rg-pct.tmdl
skills/power-bi/powerbi-skill-workspace/iteration-1/eval-1-dax-measure/without_skill/timing.json
skills/power-bi/powerbi-skill-workspace/iteration-1/eval-2-add-table/with_skill/outputs/Dim_Advisor.pq
skills/power-bi/powerbi-skill-workspace/iteration-1/eval-2-add-table/with_skill/outputs/Dim_Advisor.tmdl
skills/power-bi/powerbi-skill-workspace/iteration-1/eval-2-add-table/with_skill/outputs/relationships-addition.tmdl
skills/power-bi/powerbi-skill-workspace/iteration-1/eval-2-add-table/with_skill/timing.json
skills/power-bi/powerbi-skill-workspace/iteration-1/eval-2-add-table/without_skill/outputs/Dim_Advisor.pq
skills/power-bi/powerbi-skill-workspace/iteration-1/eval-2-add-table/without_skill/outputs/Dim_Advisor.tmdl
skills/power-bi/powerbi-skill-workspace/iteration-1/eval-2-add-table/without_skill/outputs/relationships-addition.tmdl
skills/power-bi/powerbi-skill-workspace/iteration-1/eval-2-add-table/without_skill/timing.json
skills/power-bi/powerbi-skill-workspace/iteration-1/eval-3-connector-auth/with_skill/outputs/troubleshooting-response.md