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
Decision gist · record as of 2026-07-22
Power BI skill builds end-to-end projects in PBIP format with TMDL models, Power Query, and DAX. 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.
Use it when
- The power-bi skill teaches you to build semantic models using TMDL, the text-based format for Tabular models.
- Power BI's Power Query editor lets you step through M expressions, inspect intermediate results, and validate transformations.
Verify before relying
Read SKILL.md below before installing (30 files). Open directory: indexed for reading, not audited.
Install
julianobarbosa/claude-code-skills/power-bi · repository language: Python
Open directory. Skills are indexed for reading, not audited. Review a skill's body before installing it.
Frequently 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)
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
Let your AI agent find skills like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 56,283 agent skills by what they can do, searchable in plain language.
wish › “Build end-to-end Power BI projects using PBIP format with TMDL models and Power Query”
Give your agent the search over MCP, or paste the wish link into any chat. No install? Search from any chat →
Related skills
Tmdl offers hands-on support for writing and modifying TMDL files in Power BI projects, covering measures, columns, relationships, and syntax rules. It's designed as a focused alternative when dedicated tools like Tabular Editor CLI aren't available, handling text-level edits, DAX formatting, and structural guidance. Use the pbip-validator skill to catch syntax and indentation errors before loading models in Power BI Desktop.
Power Bi Build creates IPPF-branded Power BI projects by writing DAX measures into your semantic model, applying the IPPF Visual Identity 2025 theme, and generating page recipe templates for indicator dashboards, equity disaggregation, and methodology cards. It works with the pbi CLI to automate model operations while staging report pages for manual refinement in Power BI Desktop.
Pbip covers the developer-mode file format for Power BI, which decomposes binary `.pbix` files into human-readable text folders for source control and external editing. Learn project structure, thick vs thin report patterns, semantic model and report separation, and how to handle renames and validation across components.
This skill teaches AI agents to architect and deploy Power BI semantic models, reports, and Fabric workflows using industry-standard tools like TMDL, PBIR, Tabular Editor, and CLI utilities. Agents gain hands-on capability to validate project structures, author DAX measures, write Best Practice Analyzer rules, and automate end-to-end analytics pipelines.
Expert guidance for connecting to Power BI Desktop's local tabular model using the Tabular Object Model and ADOMD.NET in PowerShell. Covers enumeration, DAX queries, model modification, and Desktop Bridge operations for reloading and verification.
Power BI Visuals enables you to create, bind, and manage 32+ visual types on PBIR report pages directly via pbi-cli, without needing Power BI Desktop. Supported visuals include bar charts, line charts, scatter plots, matrices, KPIs, gauges, and more, each configurable with custom positioning, sizing, and data binding. Bulk operations let you apply changes across multiple visuals at once by type or name pattern.
More skills Power BI DAX (MIT) · Power BI Themes (MIT)