Updated: February 23, 2022 (September 9, 2019)

  Charts & Illustrations

Power BI Components Overview

My Atlas / Charts & Illustrations

299 wordsTime to read: 2 min
Andrew Snodgrass by
Andrew Snodgrass

Andrew analyzes and writes about Microsoft's data management, business intelligence, and machine learning solutions, as well as aspects of licensing... more

Power BI is Microsoft’s business intelligence (BI) offering that contains several tightly integrated software and Microsoft-hosted components, which are used collectively to create and share reports, dashboards, and other forms of BI.

Data modeling (left). Data engineers create shared datasets using Power BI Desktop, Analysis Services semantic data models via SQL Server Data Tools, and data integration pipelines via Power BI Dataflows, a feature that provides extract, transform, and load (ETL)-type capabilities.

Report design (middle left). Power BI reports are created by authors and developers using Power BI Desktop (a free Windows desktop report design tool), current versions of Excel, SQL Server Reporting Services tools, and programmatically via a Power BI REST API. Collaboration features include workspaces, which allow multiple users to work on data models and reports together.

Back end hosting (middle right). The back end infrastructure, sometimes referred to as a repository, includes five online services and one on-premises server product that are capable of hosting reports, shared datasets, semantic data models, and integration pipelines. The online services and on-premises server provide similar functionality, including access to data sources, report rendering, and user access management, but are designed for distinctly different workloads because they differ in performance and security features and vary by which report types, design tools, clients, and features are supported.

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now