Power BI

Power BI is Microsoft's business analytics platform. Authors build reports and semantic models in Power BI Desktop (Windows), publish them to the Power BI Service (app.powerbi.com), and share them with colleagues through the browser, Teams, or mobile apps. Hundreds of data connectors feed the in-memory engine; DirectQuery and Direct Lake allow live queries against large external sources. Power BI Pro is required to share content; Premium Per User and Microsoft Fabric capacities unlock larger models, paginated reports, and the broader Fabric data platform. Power BI is the default analytics layer for Microsoft 365 customers.

Worked example

A regional sales director wants a live view of pipeline by territory, refreshed automatically each morning rather than a manually updated Excel workbook someone emails around weekly. An analyst builds a report in Power BI Desktop against the CRM's data connector, publishes it to the Power BI Service, and embeds it as a tab directly inside the sales team's Teams channel. Every morning the dataset refreshes on schedule, and any sales manager with the right Power BI Pro licence sees the same current numbers without ever opening a separate application or waiting for someone to send an update.

Common pitfalls

Publishing a report and assuming everyone who needs it can automatically see it is a common licensing gap — sharing content generally requires Power BI Pro (or a Premium capacity workspace) for both the author and, in many licensing setups, the viewer, and skipping that check produces a wave of "I can't open this report" tickets right after launch. Building overly large or poorly optimised datasets that take minutes to refresh, rather than modelling data efficiently or considering DirectQuery for genuinely large sources, is a common performance problem that only becomes visible once real users start relying on the report daily. And treating a Power BI report as a one-time deliverable rather than a living asset skips the ongoing work of keeping data sources, refresh schedules, and row-level security current as the underlying business and its access needs change.