powerbi-modeling

Guide Power BI semantic model design, DAX measures, relationships, and performance tuning.

Updated Feb 1, 2026

Search Tags:#performance optimization #data modeling #star schema #dax #power bi #semantic model

Ready to run

npx skills add https://github.com/alexandereiseghohi/comicr --skill powerbi-modeling-alexandereiseghohi

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: powerbi-modeling
Source: https://github.com/alexandereiseghohi/comicr/tree/main/skills/powerbi-modeling
Command: npx skills add https://github.com/alexandereiseghohi/comicr --skill powerbi-modeling-alexandereiseghohi

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill assists users in creating and refining Power BI semantic models, ensuring they are performant, well-structured, and follow best practices.

Core Features & Use Cases

Data Model Design: Guides users in designing star schemas, defining relationships, and classifying tables.
DAX Optimization: Helps in writing efficient DAX measures and understanding naming conventions.
Performance Tuning: Provides recommendations for optimizing model size and query speed.
Use Case: A user needs to create a new Power BI model for sales data. They can use this Skill to define fact and dimension tables, establish relationships, and write initial DAX measures for key metrics like 'Total Sales' and 'Year-over-Year Growth'.

Quick Start

Use the powerbi-modeling skill to create a new measure named 'Total Revenue' that sums the 'SalesAmount' column from the 'Sales' table.

Frequently Asked Questions about powerbi-modeling

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

FAQPage Schema

How do I design a star schema for my Power BI data model?▼

To design a star schema for Power BI, you classify tables as fact or dimension entities and configure their relationships. This structure organizes dimensional attributes around central fact tables to optimize query performance.

What is the best way to optimize DAX measures for performance?▼

The best way to optimize DAX measures is to follow naming conventions and write efficient expressions based on Microsoft Learn documentation. This ensures your semantic model measures execute queries rapidly and consume memory efficiently.

How do I configure relationships and implement RLS in a semantic model?▼

You configure relationships and implement Row-Level Security (RLS) by defining table connections and security filtering rules within your semantic model. This restricts data access per user while maintaining the integrity of your star schema.

Why does my Power BI semantic model have slow query speed?▼

Slow query speed in a Power BI semantic model often results from poor data modeling, inefficient DAX measures, or oversized tables. Performance tuning addresses these by optimizing model size and applying star schema best practices.

Do I need to follow specific naming conventions for Power BI data modeling?▼

You need to follow specific naming conventions for Power BI data modeling to ensure DAX measures and semantic model objects are easily readable and maintainable. This standardization prevents errors during performance tuning and relationship configuration.