Power BI Modeling

Build and manage Power BI semantic models with pbi-cli.

Updated Apr 17, 2026
One-click install
npx skills add https://github.com/marcelodfelman/pbi-skills --skill power-bi-modeling
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Power BI Modeling
Source: https://github.com/marcelodfelman/pbi-skills/tree/main/power-bi-modeling
Command: npx skills add https://github.com/marcelodfelman/pbi-skills --skill power-bi-modeling

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill simplifies the creation and maintenance of Power BI semantic models by automating complex modeling tasks such as tables, measures, relationships, and time intelligence structures.

Core Features & Use Cases

  • Semantic Model Management: Create and manage tables, columns, measures, relationships, hierarchies, calculation groups, and date tables through pbi-cli.
  • DAX and Modeling Guidance: Handle multi-line DAX expressions, calculation patterns, formatting, and common Power BI modeling pitfalls.
  • Use Case: Build a star schema for a sales analytics model by creating fact and dimension tables, connecting relationships, adding calendar logic, and defining business measures.

Quick Start

Use the Power BI Modeling skill to create a semantic model with sales tables, relationships, date tables, and measures using pbi-cli.

Frequently Asked Questions about Power BI Modeling

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

FAQPage Schema
How do I build a star schema semantic model in Power BI?

To build a star schema semantic model in Power BI, you need to create fact and dimension tables, define relationships, add date tables, and write DAX measures. This process structures your data for analytical querying.

What's the best way to manage DAX measures and calculation groups in a Power BI semantic model?

Managing DAX measures and calculation groups in a Power BI semantic model requires handling multi-line expressions and formatting rules. Applying consistent calculation patterns prevents common modeling pitfalls and ensures accurate time intelligence.

Does Power BI semantic model manipulation require pbi-cli?

Power BI semantic model manipulation relies on pbi-cli workflows to handle model structures, TMDL compatibility, and validation. This command-line approach automates the creation and maintenance of tables, columns, and relationships.

Can I automate date table creation and hierarchies for Power BI models?

You can automate date table creation and hierarchies for Power BI models by applying semantic model management logic. This adds necessary calendar logic and structural hierarchies to support time intelligence calculations.

Why do my DAX calculations return incorrect results in a Power BI star schema?

DAX calculations return incorrect results in a Power BI star schema due to common modeling pitfalls like incorrect relationships or multi-line expression formatting errors. Applying proper calculation patterns and semantic model validation resolves these issues.

What is TMDL compatibility when working with Power BI semantic models?

TMDL compatibility in Power BI semantic models ensures that model structures like tables, columns, and measures are formatted and validated correctly. It supports reliable pbi-cli workflows for ongoing model manipulation.