Skip to main content

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge
Read in English Edit

Share via

Facebook x.com LinkedIn Email

Power BI for semantic model designers

Learn how to transform data, create relationships, write DAX, and optimize semantic models in Power BI.

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
en-us
Your Privacy Choices
  • AI Disclaimer
  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2026