Power BI semantic model designer documentation

Get started with data modeling

Concept

• Understand model relationships
• What is a star schema?
• Understand storage modes
• Use the modeling view

Transform data

Concept

• Query overview
• Common query tasks

How-To Guide

• Add custom columns
• Combine files from a folder

Concept

• Query folding guidance

Build your model

How-To Guide

• Create and manage relationships
• Create measures
• Create calculated columns
• Create calculated tables
• Create calculation groups

Learn DAX

Get started

• Learn DAX basics
• DAX overview

Tutorial

• Create calculated columns tutorial
• Create measures tutorial

Reference

• DAX function reference

Optimize performance

Concept

• Reduce data model size
• DirectQuery model guidance
• Composite model guidance
• Optimization guide

Advanced modeling

Concept

• Composite models
• Aggregations
• Field parameters

How-To Guide

• Row-level security guidance
• Use external tools