Skip to content
BENIBIX Learn

Power BI

Also known as Microsoft Power BI, Power BI Desktop, Power BI Service

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

Think of it like

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

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.

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.
In Power BI, the middle box is the model. Its sums are written in DAX.

Common mistake

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

Key takeaways

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

Compare