# Power BI

> Microsoft's BI tool. Reports sit on a model, with sums written in DAX.

**Field:** Data Engineering  
**Category:** Analytics & BI  
**Also known as:** Microsoft Power BI, Power BI Desktop, Power BI Service

## Think of it like

It is like a toolbox that comes free with your house. You already have it, so you use it.

## Definition

Power BI is Microsoft's BI tool for making reports and charts from a firm's data. Reports are built in Power BI Desktop and shared online through the Power BI service. Data is loaded into a model. The model holds the tables, the links between them and the measures. Measures are written in a formula language called DAX. It works closely with Excel, Teams and the rest of Microsoft 365.

## Example

A finance team loads its books into Power BI. It writes a measure for profit and shares the report in Teams.

## Why it matters

Many firms already pay for Microsoft 365. So Power BI is often the BI tool they have to hand.

## Common mistake

Making a new model for each report. Share one model across them, so the numbers match.

## Three principles

- **Desktop and service.** Build on a PC, share online.
- **Semantic model.** Tables, links and measures in one place.
- **DAX measures.** Numbers written as formulas.

## Related terms

- [Data Analysis Expressions (DAX)](https://learn.benibix.com/term/data/dax)
- [Semantic Layer](https://learn.benibix.com/term/data/semantic-layer)
- [Tableau](https://learn.benibix.com/term/data/tableau)
- [Looker](https://learn.benibix.com/term/data/looker)
- [Microsoft Azure](https://learn.benibix.com/term/infrastructure/microsoft-azure)
- [Power Query](https://learn.benibix.com/term/data/power-query)

## Told apart from

- [Tableau vs Power BI](https://learn.benibix.com/compare/tableau-vs-power-bi): People think Tableau and Power BI are the same tool from two firms, and they lean different ways. Tableau is built to explore. Drag fields onto a page, and a chart appears. Power BI is built on a data model, with sums written in DAX. It comes with many Microsoft 365 plans. Firms on Microsoft often pick Power BI. Teams that explore a lot often pick Tableau.

![Warehouse tables on the left feed a semantic layer in the middle, which holds one definition of revenue as the sum of amount, plus dimensions for country and month. Three tools on the right, a dashboard, a spreadsheet and an AI assistant, all ask for revenue and all get the same number.](https://learn.benibix.com/diagrams/semantic-layer.svg)

---

Source: https://learn.benibix.com/term/data/power-bi
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
