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.3
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.6
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 7.9

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

(1783)

Attribute Ratings

Reviews

(76-100 of 140)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Power BI is being used to create dashboards and company data reports. Currently, it is used in the financial and IT areas. We are working on planning to have a vision of what is to come, planning everything about the company through the visual representation of these sensitive data. And with it, the tool can generate great visualizations that we can take to meetings.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Currently, Microsoft Power BI is being used by some departments on our organization. Basically, the financial department, and the IT department. Microsoft Power BI is very useful to build numerous dashboards in order to support post-data gathering for all core processes. Furthermore, Microsoft Power BI can build many possible charts. We can use them to show information or even full interactive presentations, that in Microsoft Excel we could not do. Microsoft Power BI has integration with the other Microsoft business tools, and this is really helpful.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Power BI is used across the whole organization. Although our company uses many BI tools, there is currently a project to consolidate tools and make Power BI our official BI tool. It's used across each department to provide analytics and insight into each department's OKRs. Our IT team has a specific division that is the main driver behind adoption and consulting on dashboarding for each department.
Maria Carver | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Great platform for data visualization and data analyzes. The organization is migrating to Power BI because of its integration with Microsoft applications. R is very well integrated with Power BI which makes statistical modelling easier to use. Report generation and sharing has become very simple. Very useful to create dashboards for the top management to make data driven business decisions.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
It is used as an official data visualization solution and all departments have the ability to implement it. It is an important piece of our digital and analytics journey and Power BI is supporting this journey enabling better user experience and powerful dashboards with charts and KPIs. We are improving our operational efficiency and decision-making process.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Our Company is a Microsoft shop so naturally, we use all products from Microsoft. Microsoft Power BI is being used in all levels and all departments in my organizations. In our department alone, every team has on average of 5 power BI reports that we actively use everyday. We have created Power BI reports that are also consumed by the E class. The visual aspect of this tool is the most interesting part of the value it brings in providing information. As a Microsoft shop, we use Excel and have been creating enormous amount of reports from it. Because of this the transition to Power BI was not prolonged but rather adopted rather rapidly. Today we have training sessions, Knowledge articles and access to the experts when it comes to doing things thru Power BI. Although we do use other enterprise level reporting tools, power BI Is the most widely used in our company.
Peter Baker | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We built out numerous dashboards in order to support the analysis post-data gathering for all our core discovery methodologies.

This allowed us to quickly spin up are variable data sets mid- and or post-project in order to start validating results and identify areas required for cleaning etc. prior to analysis and presentation back to our clients with the results.

The free visual market place really helped bolster the initially limiting range of visualizations it comes with out of the box.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Our organization uses Power BI across the organization and globally to our network of partners. Several problems were addressed by implementing Power BI.
  1. Report building: Reports can now be built by anyone in the organization with access to the data source where previously it required a developer.
  2. Time required: Along the same lines, the time required to release a new report or update an existing report has decreased significantly and can usually be done the same day.
  3. Embedding: Reports needed to be embedded in our partner portal and allow filtering based on the user so that we're showing the right data to the right people.
  4. One-off reports: There used to be an alarming number of requests for one time or monthly or weekly reports that were manually generated. The data is now accessible via Power BI in a controlled way that allows our users to find their own insights in the data.
Jewemars Christian Riano | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Power Business Intelligence is being used as a tool for monitoring critical systems, capacity, and system behaviors. It is an essential tool for daily monitoring and operations, it is being widely used in our company as a tool to keep track of data and make sensible data. It also gives us the opportunity to create great visualizations and pleasing presentations in meetings or in data tracking.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We are a software development company with a Business Intelligence and Analytics arm. We work with our clients and try to solve their business problems. Sometimes this involves deploying Microsoft Power BI solutions.
Maria Piccoli | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Power BI is used across departments. The IT department checks all the helpdesk incoming calls/emails.The web analytics have dashboards for customer searches and location. The sales department reports on profit and forecasting.
Mathieu Gaouette | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Power BI is being used to build dashboards and reports. It is used mainly by the marketing department as far as I know but I really wouldn't be surprised that it is being used in other departments. It allows us to have an insight into our business through the visual representation of our data. With this new breed of "reporting tool" (like Tableau software), we are able to simplify the data to allow easy communication to higher management. Power BI helps management make business decisions based on data (ex, whether to close or open branches based on customers in a region, launch refinancing campaign in regions where the mortgage to value rate is low, etc.).
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Microsoft Power BI is currently in use by departments who really want to dig into their data and give additional meaning to what they typically might see on a spreadsheet. It is not in use across the entire organization here, but rather by individual departments who have taken some initiative to get more out of their data. The big problem it addresses is the ability to visualize large complex data sets in simple, easy to read ways.
Toby Wenzel | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We are fairly new to Power BI, and it's being evaluated by our development team. I've tested the product on a couple of items, and am pretty impressed with how easy it is to figure out without help. I quickly created some easy to read graphs from an Excel spreadsheet. I will be testing more when I have free time.
Francois Salvert | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Power BI is mainly used in the Marketing/BI group by analysts. Its main use is to dig into various datasets in order to find answers to various questions directors and VP may ask. Power BI is not really used to produce dashboards but more for reporting (for ad-hoc queries). For example, if there is a specific promo code being used on a given day more than normal, we will use Power BI to investigate patterns from users that have entered this problematic promo code to see if it's legit or not.
Brian Munn | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We are using Microsoft Power BI throughout or entire organization. Our finance department was the first group to start using Power BI. The ability to display the data easily and with ease of understanding is the key to Power BI. Users can quickly take data from a variety of data sources and display in an easy to read user friendly format. Power BI allows our users to see important data timely without scrolling through a bunch of Excel files.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We started small with few key users in planning and finance areas. Now we have established a governance team and started training and deploying across different functional areas from production, planning, sales, warehouse, quality and others.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We have designed an additional layer over Atlassian JIRA and enhanced significantly analytical drilldowns in a SW development projects, software maintenance and end user support. We have also developed custom API to JIRA to efficiently gather JIRA data and process and present them in Power BI dashboards. The management was first skeptical, since the JIRA service desk team already had some reports done in the native JIRA environment. However we have convinced them that the connection of Power BI and JIRA logs makes a sense. Today it is used to visualize flow, detect anomalies (too many cycles, overused programmer resources etc.) in a perfect visual form.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
In my current marketing firm, we have clients from all across the globe that we service. We felt the need for providing better analytics for our marketing and sales representatives. We wanted to incorporate a business intelligence tool into our enterprise to get a full 360 view of our mission critical data. Microsoft BI helped fill that role.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Microsoft PowerBI is used by the organization to reflect the performance of sales and individual accounts. The Sales team has been using PowerBI to contact customers and reflect on their performance. It is being used to solve the problem of having near real time performance. The tool is also used to drill down on more detailed information and serves as a proxy CRM tool to retrieve additional account information (contact info).
Angad Singh | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Microsoft Power Bi is being used by among J&J for data visualization and reporting. My team was using it to visualize and report on certain metrics from our data catalog. I'm not sure if it is used organization wide, but there are many teams in working with data that utilize it. BI makes it convenient for teams to report data to higher management by visualizing it into easy to understand representations.
Gonzalo Angeleri | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Microsoft Power BI can be used by the entire organization, however, in our experience it is mainly used in a departmental way for reporting and dashboarding. Power BI allows users to perform, in a simple way, a complete analysis of their data using different visualizations. Companies can see trends in the data and what is the best way to use them for future decisions.
Return to navigation