Business Intelligence Software · Enterprise BI
Microsoft Power BI
by Microsoft
Microsoft's BI platform, combining desktop authoring with a cloud service and an on-premises report server option.
What it is
Power BI is the most widely deployed platform in this category, largely because it arrives with an existing Microsoft agreement rather than as a separate procurement. It splits into Power BI Desktop for authoring, the Power BI service for sharing and governance, and Power BI Report Server for organisations that must keep reporting on their own infrastructure.
Its distinguishing strength is the modelling layer. The combination of a columnar in-memory engine and the DAX expression language lets you build a governed semantic model that many reports then share, which is what separates it from tools that chart a query result. That same layer is where most Power BI projects go wrong, because model design is a genuine skill and an unplanned model becomes slow and hard to change.
The practical caution is licensing and capacity, which is more consequential here than in most competitors and is the single most common source of unbudgeted cost.
Capabilities
Each capability carries its own verification status. “Not verified” means exactly that: it has not been checked, and must not be read as absent.
| Capability | Status | Notes |
|---|---|---|
| Interactive dashboards Dashboards users can filter and drill into rather than static images. | Yes | source |
| Data visualisation The chart library and formatting control available to authors. | Yes | source |
| Self-service analytics Business users building their own analysis without a developer. | Yes | source |
| Scheduled reporting Reports generated and distributed on a timetable. | Yes | source |
| Embedded analytics Charts and dashboards surfaced inside another application. | Yes | source |
| Data modelling A governed semantic layer defining measures and relationships. | Yes | source |
| Data connectivity Breadth of native connectors to databases and services. | Yes | source |
| AI-assisted analytics Natural-language query or generated insight features. | Yes | source |
| Role-based access control Permissions by role, including row-level restriction. | Yes | source |
| Mobile access A supported mobile app or responsive consumption experience. | Yes | source |
| Vendor-managed cloud A hosted service operated by the vendor, so you do not run it yourself. | Yes | source |
| Paginated and pixel-perfect reporting Fixed-layout output for statutory, regulatory or print reporting. | Yes | source |
| Free self-hosted edition A no-licence-cost edition you can run on your own infrastructure. | No | source |
| Usage or session-based reader licensing Readers charged by use rather than per seat, which changes the cost of a large occasional audience. | No | source |
| Planning and budgeting Forecasting and budget entry in the same product as the reporting. | No | source |
| Native dbt metric integration Reads models and metrics directly from a dbt project rather than a separate modelling layer. | No | source |
| Associative exploration engine Selections re-evaluate the whole dataset and reveal excluded, unrelated values. | No | source |
Deployment
| Model | Supported |
|---|---|
| Cloud (vendor hosted) | Yes |
| On-premises / self-hosted | Yes |
| Hybrid | Yes |
Integrations
Databases
Cloud platforms
- Microsoft Azure source
ERP systems
- Dynamics 365 Business Central source
Data warehouses
APIs
- REST API source
Business applications
Licensing and pricing
| Item | Value |
|---|---|
| Licensing model | Commercial |
| Free version | Yes |
| Trial available | Yes |
| Published price | USD 14 per user per month (Power BI Pro, billed annually) |
| Note | Power BI Pro is USD 14.00 and Premium Per User USD 24.00, both per user per month paid yearly, as published on 7 November 2026. Microsoft states on that page that its figures are "for marketing purposes only" and that the actual price appears at checkout, so treat these as indicative. Embedded and Fabric capacity are quoted separately and are not per-user. |
| Official pricing page | Vendor pricing |
| Pricing last checked | 7 November 2026 |
Prices move and discounting is common. Treat anything here as a starting point and confirm with the vendor before budgeting.
Strengths and limitations
Strengths
- Deep semantic modelling with a governed, reusable model layer. editorial
- An on-premises report server option exists alongside the cloud service. verified source
- Very broad native connectivity, including Microsoft ERP and warehouse estates. editorial
- Low entry cost where Microsoft licensing is already held. editorial
Limitations
- Licensing and capacity planning is genuinely complicated and is where budgets slip. editorial
- Effective use depends on model design skill, which many teams underestimate. editorial
- The on-premises report server lags the cloud service in features. editorial
Who it suits
Organisation sizes: Small, Medium, Enterprise
A natural default where Microsoft 365 and Azure are already in place and the reporting audience is broad. It scales from a single analyst to enterprise deployment, and the on-premises report server keeps it viable where data cannot leave the estate.
Less compelling where the organisation has no Microsoft footprint, or where the main requirement is embedding analytics into a commercial product for external customers, which specialists do more cleanly.
Alternatives
See the full Microsoft Power BI alternatives guide
Compared with other products
- Power BI vs Tableau
- Power BI vs Qlik
- Power BI vs Looker
- Power BI vs Metabase
- Amazon QuickSight vs Power BI
Frequently asked questions
Yes. The service runs on Microsoft's cloud regardless of whether you use Azure for anything else, and Power BI Report Server can run on your own infrastructure. Azure is a common data source rather than a prerequisite.
Partly. Power BI Report Server is an on-premises product for publishing paginated and Power BI reports inside your own network. It is not feature-equivalent to the cloud service, so check that what you need is supported before committing.
Fabric is the wider data platform that Power BI now sits inside. If you are weighing that move, the operational detail is in our articles on migrating Power BI workloads to Fabric and Fabric capacity sizing and cost.
Sources and review basis
- Evaluation basis: vendor documentation and public sources, not hands-on testing
- Last reviewed: 7 November 2026
- Vendor: Microsoft
- Documentation: Official docs
References
- Microsoft Power BI product site accessed 7 November 2026
- Microsoft Power BI documentation accessed 7 November 2026
- Microsoft Power BI pricing page accessed 7 November 2026
Disclosure
Alongside advisory work I also build a CMMS and CAFM platform, so I have a commercial interest in enterprise software generally. No vendor in this directory has paid for inclusion, placement or wording, and there are no reseller or affiliate arrangements. Weigh the analysis accordingly.
Evaluating Microsoft Power BI?
Independent help testing it against your actual requirement, and designing the data integration it will depend on. 22+ years across ERP, EAM, CAFM and enterprise integration. No reseller arrangements.
Book a conversationOn this page
At a glance
- Vendor
Microsoft - Category
Business Intelligence Software - Primary use
Enterprise BI - Deployment
Cloud, On-premises, Hybrid - Licensing
Commercial - Status
Active