What is Power BI?
Power BI is a self-service BI tool consisting of a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights.
Your data may be Excel spreadsheets, ERP (SAP, Dynamics), CRM, internal-external databases or a collection of cloud-based and on-premises hybrid data warehouses.
These no-code or low-code tools (part of Microsoft 365 E5 enterprise licenses) are easy to handle and provide available info anytime-anywhere-any device (pc-mac-smartphone-tablet)
The main elements of Power BI
Power BI consists of:
A common flow of work in Power BI begins by connecting to data sources and building a report in Power BI Desktop. You then publish that report from Power BI Desktop to the Power BI service, and share it so end users in the Power BI service and mobile devices can view and interact with the report. This workflow is common, and shows how the three main Power BI elements complement one another.
Following is a conceptual illustration* of the most common capabilities:
How is Power BI Priced?
Power BI comes in three levels – Pro, Premium per user and Premium per capacity
€8.40 / $9.99 Per user/month
*Included with Office 365 Enterprise E5
€16.90 / $20.0 Per user/month*
The Premium plan is an extension of Power BI Pro for higher data set size and higher frequency of data refresh, and additionally:
from €4,212 /$4,995 Per capacity/month
Power BI Premium consists of capacity in the Power BI service exclusively allocated to each organization.
The capacity is supported by dedicated hardware fully managed by Microsoft. Organizations can choose to apply their capacity broadly, or allocate it to assigned workspaces based on the number of users, workload needs, or other factors—and scale up or down as requirements change.
The most prominent components* of the Power BI suite of tools are defined as follows:
The ecosystem as a whole which includes a collection of software services, applications, and connectors that facilitate the creation of reports and dashboards and the visual analysis of information.
Power BI Desktop
Power BI Desktop is a desktop-based authoring tool of choice for connecting, transforming, and modeling data for creating interactive reports. There are two Power BI Desktop executables available: one which is updated monthly and aligns with the Power BI Service, and one which aligns with the capabilities of Power BI Report Server and is updated less frequently (approx. 3x/year). Files produced by both versions work with Power BI Service. Power BI Desktop saves reports as files in the .pbix format.
Power BI Service
The Power BI Service is a cloud-based service that supports collaboration, sharing, enterprise distribution, creation of dashboards, and additional functionality such as alerts. Online resources may refer to it as:
Power BI App Workspace
A Power BI App Workspace is a collaboration area within the Power BI Service. An App Workspace is a distinct area, separate from My Workspace, which is dedicated to a specific team, subject area, or project. Power BI and Excel reports are published to an App Workspace so that colleagues can view the content, and contribute as appropriate.
Power BI App
A Power BI App is a set of packaged up content in the Power BI Service for the purpose of distributing related reports and dashboards to a larger base of consuming users.
Power BI Mobile Apps
Power BI Mobile Apps are native applications for iOS, Android, and Windows for viewing reports and dashboards on a mobile device.
On-Premises Data Gateway
The On-Premises Data Gateway is an agent installed within the corporate network to allow secure access to organizational data stored on-premises. There are two gateway modes: Enterprise mode and Personal mode.
Power BI Premium
Power BI Premium is an offering that provides dedicated resources for reports, dashboards, and datasets within the Power BI Service. This provides organizations more predictable performance, larger storage volumes, larger dataset sizes, higher refresh rates, and incremental data refresh. Premium also enables widespread distribution of content without requiring a Pro license for each read-only user.
Power BI Report Server
Power BI Report Server is an alternative to the Power BI Service for deploying Power BI reports within an on-premises data center, as opposed to the cloud-based Power BI Service. Power BI reports are deployed and delivered in an on-premises portal alongside Reporting Services reports, Excel reports, and Mobile reports.
Power BI Embedded