Skip to main content
TrustRadius
Microsoft Power BI

Microsoft Power BI

Overview

What is Microsoft Power BI?

Microsoft Power BI is a visualization and data discovery tool from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale across their organization with built-in…

Read more
Recent Reviews

Power Packed Microsoft Power BI

8 out of 10
October 04, 2023
I used Microsoft Power BI for regular data analysis and report generation.
I use to deal with a lot of financial data and Microsoft Power …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 29 features
  • Customizable dashboards (138)
    8.0
    80%
  • Drill-down analysis (138)
    7.2
    72%
  • Report sharing and collaboration (134)
    7.0
    70%
  • Formatting capabilities (137)
    6.4
    64%

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Pricing

View all pricing

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://powerbi.microsoft.com/en…

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Starting price (does not include set up fee)

  • $10 per month per user
Return to navigation

Product Demos

Microsoft Power BI Guided Tour

powerbi.microsoft.com
Return to navigation

Features

BI Standard Reporting

Standard reporting means pre-built or canned reports available to users without having to create them.

7.2
Avg 8.2

Ad-hoc Reporting

Ad-Hoc Reports are reports built by the user to meet highly specific requirements.

7
Avg 8.1

Report Output and Scheduling

Ability to schedule and manager report output.

7.8
Avg 8.4

Data Discovery and Visualization

Data Discovery and Visualization is the analysis of multiple data sources in a search for patterns and outliers and the ability to represent the data visually.

7.5
Avg 8.1

Access Control and Security

Access control means being able to determine who has access to which data.

8.2
Avg 8.6

Mobile Capabilities

Support for mobile devices like smartphones and tablets.

7.9
Avg 8.0

Application Program Interfaces (APIs) / Embedding

APIs are a set of routines, protocols, and tools for used for embedding one application in another

8.4
Avg 7.9
Return to navigation

Product Details

What is Microsoft Power BI?

Power BI: Comprehensive Business Intelligence Platform


Capabilities:

  • Discover Insights with AI: Utilizes advanced data-analysis tools, AI features, and a report-creation tool to transform complex data into accessible visuals, making it easier to uncover valuable insights.

  • Consolidate Data with OneLake: Integrates datasets from diverse sources into OneLake, creating a centralized, reliable source of truth for data. This integration reduces data duplication and simplifies analysis.

  • Drive Decision-Making: Infuse actionable insights into everyday applications like Microsoft 365, enhancing decision-making processes across the organization.

  • Empower Data Teams with Microsoft Fabric: Revolutionizes organization's data management and usage by incorporating Microsoft Fabric into the Power BI experience.


Key Differentiators:

  • Scalability: Power BI offers exceptional scalability, capable of transforming petabytes of data and supporting thousands of users without compromising performance.

  • Integration with Microsoft Ecosystem: Seamlessly embed and share insights across Microsoft services like Teams, PowerPoint, Excel, and the Power Platform, ensuring coherent and unified data handling.

  • Advanced AI Capabilities: Features AI tools that automatically find patterns, generate reports, and provide insights, enhancing efficiency and accuracy.

  • Robust Data Governance: Ensures data security and compliance with Microsoft's comprehensive governance and protection measures.


Copilot in Power BI:

  • Efficient Report Generation: Generates reports rapidly using conversational language. Copilot in Power BI enables quick creation of DAX calculations, summaries, and tailored reports.


Integration with Microsoft Fabric:

  • Enhanced Accessibility: Allows interaction with reports and data across Microsoft Fabric workloads, even for users without paid licenses.

  • OneLake Data Hub: Facilitates the connection and curation of data from varied sources, promoting efficient data engineering.


Power BI PRO:

  • Self-Service Analytics: License individuals for self-service analytics, enabling them to publish and share reports, fostering a culture of self-service BI.


Free Account Options:

  • Power BI Desktop & Free Trial: Offers a free app for data connection, modeling, and visualization, along with an easy-to-use report canvas.

  • Comprehensive Training: Access step-by-step Microsoft training courses to fully leverage Power BI capabilities.


Key Benefits:


  • Unified Data Management: Connect disparate data sources to establish a governed, unified source of truth.

  • Empower All Users: Ensures accessibility and ease of use for everyone, supported by free training resources and numerous accessibility features.

  • Immediate Start: Quickly begin with report creation, AI-generated reports, and a wide range of templates.

  • Customer Engagement: Enhance user engagement in apps by embedding Power BI reports.



Microsoft Power BI Features

BI Platform Features

  • Supported: Administration via Windows App
  • Supported: Administration via Web Interface
  • Supported: Live Connection to External Data
  • Supported: Snapshot of External Data
  • Supported: In-memory data model
  • Supported: OLAP (Pre-processed cube representation)
  • Supported: ROLAP (SQL-layer querying)
  • Supported: Multi-Data Source Reporting (Blending)
  • Supported: Data warehouse / dictionary layer
  • Supported: ETL Capability

Supported Data Sources Features

  • Supported: MS Excel Workbooks
  • Supported: Text Files (CSV, etc)
  • Supported: Oracle
  • Supported: MS SQL Server
  • Supported: IBM DB2
  • Supported: Postgres
  • Supported: MySQL
  • Supported: ODBC
  • Supported: Cloudera Hadoop
  • Supported: Hortonworks Hadoop
  • Supported: EMC Greenplum
  • Supported: IBM Netezza
  • Supported: HP Vertica
  • Supported: ParAccel
  • Supported: SAP Hana
  • Supported: Teradata
  • Supported: Sage 500
  • Supported: Salesforce
  • Supported: SAP
  • Supported: Google Analytics

BI Standard Reporting Features

  • Supported: Pixel Perfect reports
  • Supported: Customizable dashboards
  • Supported: Report Formatting Templates

Ad-hoc Reporting Features

  • Supported: Drill-down analysis
  • Supported: Formatting capabilities
  • Supported: Predictive modeling
  • Supported: Integration with R or other statistical packages
  • Supported: Report sharing and collaboration

Report Output and Scheduling Features

  • Supported: Publish to Web
  • Supported: Publish to PDF
  • Supported: Output Raw Supporting Data
  • Supported: Report Versioning
  • Supported: Report Delivery Scheduling
  • Supported: Delivery to Remote Servers

Data Discovery and Visualization Features

  • Supported: Pre-built visualization formats (heatmaps, scatter plots etc.)
  • Supported: Location Analytics / Geographic Visualization
  • Supported: Predictive Analytics
  • Supported: Support for Machine Learning models
  • Supported: Pattern Recognition and Data Mining
  • Supported: Integration with R or other statistical packages

Access Control and Security Features

  • Supported: Multi-User Support (named login)
  • Supported: Role-Based Security Model
  • Supported: Multiple Access Permission Levels (Create, Read, Delete)
  • Supported: Report-Level Access Control
  • Supported: Table-Level Access Control (BI-layer)
  • Supported: Field-Level Access Control (BI-layer)
  • Supported: Single Sign-On (SSO)

Mobile Capabilities Features

  • Supported: Responsive Design for Web Access
  • Supported: Mobile Application
  • Supported: Dashboard / Report / Visualization Interactivity on Mobile

Application Program Interfaces (APIs) / Embedding Features

  • Supported: REST API
  • Supported: Javascript API
  • Supported: Java API
  • Supported: Themeable User Interface (UI)

Microsoft Power BI Screenshots

Screenshot of Microsoft Power BI - Turns insights into impact for business usersScreenshot of Power BI integrates easily with Microsoft 365Screenshot of Microsoft Power BI - AI-Powered CapabilitiesScreenshot of Microsoft Power BI - Copilot can be used to create reportsScreenshot of Microsoft Power BI - Data HubScreenshot of Microsoft Power BI - Scales as organizational needs growScreenshot of Microsoft Power BI - Data Governance

Microsoft Power BI Competitors

Microsoft Power BI Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsWindows
Mobile ApplicationApple iOS, Android, Windows Phone, Mobile Web
Supported CountriesAsia Pacific, Australia, Brazil, Canada, China, Europe, France, Germany, India, Japan, Korea, Norway, South Africa, Switzerland, United Arab Emirates, United Kingdom, United States
Supported LanguagesArabic, Basque - Basque, Bulgarian - Български, Catalan - català, Chinese (Simplified) - 中文(简体), Chinese (Traditional) - 中文(繁體), Croatian - hrvatski, Czech - čeština, Danish - dansk, Dutch - Nederlands, English - English, Estonian - eesti, Finnish - suomi, French - français, Galician - galego, German - Deutsch, Greek - Ελληνικά, Hebrew, Hindi - हिंदी, Hungarian - magyar, Indonesian - Bahasa Indonesia, Italian - italiano, Japanese - 日本語, Kazakh - Қазақ, Korean - 한국어, Latvian - latviešu, Lithuanian - lietuvių, Malay - Bahasa Melayu, Norwegian (Bokmål) - norsk (bokmål), Polish - Polski, Portuguese (Brazil) - Português, Portuguese (Portugal) - português, Romanian - română, Russian - Русский, Serbian (Cyrillic) - српски, Serbian (Latin) - srpski, Slovak - slovenčina, Slovenian - slovenski, Spanish - español, Swedish - svenska, Thai - ไทย, Turkish - Türkçe, Ukrainian - українська, Vietnamese - Tiếng Việt

Frequently Asked Questions

Microsoft Power BI is a visualization and data discovery tool from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale across their organization with built-in governance and security.

Microsoft Power BI starts at $10.

Tableau Cloud, Looker, and Domo are common alternatives for Microsoft Power BI.

Reviewers rate Javascript API highest, with a score of 9.6.

The most common users of Microsoft Power BI are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(1781)

Attribute Ratings

Reviews

(51-75 of 140)
Companies can't remove reviews or game the system. Here's why
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Power BI is a powerful tool to visualize data sets and provide easy deep dive analysis into your data. It is a great extension to Excel and easy to pick up with minimal training. It is able to address many of the business challenges faced by CPG organizations from financial analysis, supply chain management, factory optimization, and so forth.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
[Microsoft] Power BI is a natural choice for Microsoft shops looking to modernize dashboard development utilizing data management technologies likely already in place in the organization. I have used it at several companies I have worked for that were either SQL Server or Azure driven, to standardize development and presentation of dashboards for management and executives.
April 07, 2021

Powerful Power BI

Score 8 out of 10
Vetted Review
Verified User
Incentivized
It's being used across our organization...we have it used by three groups logically. One is the power users, two is the supporting staff and the third is the solution group who build solutions. We also have it for the R&D team for pulling out reports making it work against the power BI gateway from where we can pull data from out on-prem workloads. They evaluate the software.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use Power BI to support multiple areas within our organization. We have created personnel dashboards for our HR team and recruiting teams. We have financial dashboards for our Finance and AR teams. We have analytics dashboards for our operations teams. It solves so many issues and is so user friendly. The main area of improvement has been getting consistent data into the hands of our employees company wide rather than relying on spreadsheets that business units would keep internally.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
[Microsoft] Power BI is being used by our BI team (developers) and business analysts in selected Departments. It is a tool of choice for a quick data analysis and dashboard creation primary for 311 city services (service requests), Health/Vaccination (COVID) public facing analysis and purchasing improvement process.
James Anderson | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We are using Power BI in our Medical Economics department to help visualize the contracts that we negotiate with the health insurance companies. We use it to understand how those negotiated rates perform over time. We compare the insurance companies' rates to each other in various ways with different metrics.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Microsoft Power BI is used across the whole organization. In my department, I developed a Power BI based solution to better visualize the workload allocation for the engineering team in Brazil.
There is also a dashboard for observing the ongoing projects status and stages. Every department uses Power BI with different data sources but all solutions are targeting data visualization and ease of implementation.
Microsoft Power BI is a quick-to-implement software that makes it easier to deal with large datasets and create relationships between different data sources.
Marco De Angelis | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Microsoft Power BI is used by the entire IT department and by other users with personal objectives, like Excel. Power BI is used on top of other software to create business models where the software standard reports do not cover our needs and to integrate diverse data source coming from diverse software.
Shreshthi Mehta, PMP®, PHR® | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Power BI is being used by HR and IT departments. We use it typically to run weekly and monthly reports and for data analytics. It is hugely helpful in saving time as we can build in formats within the tool and schedule the metrics to run weekly/monthly. Weekly/ monthly data cuts are not required.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Power BI is used for 2 main reasons. First, the software is used for data visualization. Second, the software is used for analytics, including some minor advanced analytics. The software helps provide real-time information on time series and other data to ease the process of making decisions. It is also used for communicating data with colleagues.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
I have used Microsoft Power BI to create automated reports, dashboards for our clients finance department. The reports were consisting of financial targets, actual and forecasts. Along with the reports, we used formula generation functionalities and made auto calculations. It is a good reporting dashboard when it comes to display most current values along with auto calculations. Before Power BI, excel reports or ppt presentations would be distributed within the organization. With Power BI, the dashboards and data visualization became more professional looking.
Rick Botha | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Incentivized
Microsoft Power BI is used primarily by the Project Management department at the company to keep track of all the project metrics within the whole company, covering everything from capital expenditure projects, to customer orders, and product development projects.The different departments that aren't authoring the data and reports have access to the reports to use within their planning and departmental reports. The problem that Microsoft Power BI addresses is that everyone has clear and easy access to well displayed dashboards that display key metrics on a per project basis.
Steffany Winkelmann | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Previously, we had no real business intelligence. We had all sorts of data in our database, but we had no way to make sense of it aside of downloading and manipulating it in Excel, but this proved difficult to process many hundreds of thousands of rows of data. Microsoft Power BI has helped us make this process so much easier by connecting to our database directly and run queries directly in the system and make beautiful charts based on that data, to make sense of what's going on.
Che Odom | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use Microsoft Power BI to gather data and present it from our project management software Procore. It is used by two people in our organization to present data to our upper management. It helps to let our leadership have a real up to date high level overview of where each of our projects stand in terms of budget, schedule and many other metrics.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We have about 25 years of data. Microsoft Power BI is being used across the organization by various departments. Our accounts payables team uses it to monitor vendor activity, identify duplicate invoices, and ensure vendor compliance. Our internal audit team runs several reports to identify anomalies.
September 15, 2019

Really Great!

Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use Power BI in our IT dept, but the information and analytics gained are then provided company-wide to those who need it or could be helped by the information. It helps us easily visualize and conceptualize the data that we've always had. Insights gained are really quite valuable.
Guillermo Villamizar | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Power BI is actually being used by our entire organization. Each type of user has access to different views or reports, and they don't have to manually make the reports on another tool such as Excel, although later they can export it to Excel so they can manipulate the information or send them to another person.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
1. It is used for Executive reviews for visualization and dashboards to provide insight in the business operations, marketing, finance. My organisation is using this because it comes free with Microsoft Office license. It provides similar services as other tools in the same field.
2. It is being used in my departmen,t but other functions are starting to explore this BI tool.
3. Visualization, dashboards, scorecards, easy to understand huge datasets through graphs and charts, flexible for users to connect withEexcel

Chris Widner | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
As we are trying to understand the overall health of the organization there are various metrics around revenues, costs, etc that we want to be able to slice and dice. We have some contracts that are such severe outliers (both positive and negative) that they can greatly skew our numbers. We use PowerBI to better understand our metrics and quickly manipulate the inputs into our reports.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
A lot of Packages are available to represent the data. Predictive and Visualization representations are very useful. A lot of users are implementing new packages and share the same with other users which helps to find a quick solution to our requirements. The open Source community provides help in case of any issues or solutions needed. Such as issues with finding a central repository to find out the implementation of packages. More searches are needed for finding the details of any package, for example, any package needs to search a lot to find out the details. Recommendations to others considering the product are much needed in the understanding of our language to proceed with the tool. Data Representation, Analysis, Visualization, Detailing, Training purpose as well.
Score 6 out of 10
Vetted Review
Verified User
Incentivized
We have three BI solutions within our business, Power BI, Qlik View and Qlik Sense. Primary management reporting, dashboards and report distribution are done with Sense, basic marketing views are done through View and most power analytics and ad-hoc analytical work is done via Power BI. We find Power BI is best when data resides in several places and mostly spreadsheets. Using Power BI to connect directly into source systems (even Microsoft branded products Azure SQL Server) cause the app to time out. So company-wide we use sense, and functional analysts across all departments have Power BI to dig deeper than Sense can go.
Return to navigation