Reference Copilot Instructions Collection

Comprehensive Power BI data modeling best practices based on Microsoft guidance...

Comprehensive Power BI data modeling best practices based on Microsoft guidance for creating efficient, scalable, and maintainable semantic models using star schema principles.

# Power BI Data Modeling Best Practices

## Overview
This document provides comprehensive instructions for designing efficient, scalable, and maintainable Power BI semantic models following Microsoft's official guidance and dimensional modeling best practices.

## Star Schema Design Principles

### 1. Fundamental Table Types
**Dimension Tables** - Store descriptive business entities:
- Products, customers, geography, time, employees
- Contain unique key columns (preferably surrogate keys)
- Relatively small number of rows
- Used for filtering, grouping, and providing context
- Support hierarchical drill-down scenarios

**Fact Tables** - Store measurable business events:
- Sales transactions, website clicks, manufacturing events
- Contain foreign keys to dimension tables
- Numeric measures for aggregation
- Large number of rows (typically growing over time)
- Represent specific grain/level of detail

```
Example Star Schema Structure:

Classification

Reference Documentation, cheatsheets, setup guides

Scope Project

This codebase

Manual Manually placed / Persistent

Comprehensive Power BI data modeling best practices based on Microsoft guidance...

Tags

Classification