What is Semantic Models

Definition

A semantic model in Microsoft Fabric and Power BI is a business-friendly layer that defines tables, relationships, measures, and calculations over underlying data, so report builders and analysts query consistent, governed business logic instead of raw tables.

« Back to Glossary Index

Defines consistent business metrics and relationships once for reuse
Lets analysts build reports on governed logic, not raw tables
Centralises calculations so measures mean the same everywhere
Improves performance and self-service through a curated model

Glossary: Power BI

Real World Example

A finance team builds a semantic model defining revenue, margin, and relationships across its tables, so every Power BI report draws from the same trusted definitions rather than each analyst recreating the calculations.

FAQs

What is a semantic model?

It is a layer defining tables, relationships, and measures that presents data in business-friendly, consistent terms for reporting.

Why use a semantic model?

It ensures everyone uses the same definitions and calculations, enabling trusted, consistent self-service analytics.

How does it relate to Power BI datasets?

Semantic models are the evolution of Power BI datasets, providing the governed data layer reports are built on.