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.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 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

(1780)

Attribute Ratings

Reviews

(1-25 of 140)
Companies can't remove reviews or game the system. Here's why
Score 6 out of 10
Vetted Review
Verified User
  • For big data like from the past 2-3 years, It will give you an easy visualization of that data with required fields
  • The competitive study between the two market cases for example past data of supplier and their costs
  • We can also review and visualize our sales with a particular Product ID and in which region it has the most demand
  • The query editor is the first thing that can be improved as sometimes it takes more time to show what the exact query is.
  • Many sudden bugs keep coming which should also avoid
  • An easy way for the formatting as it is somewhat critical...One within one set of commands
Score 8 out of 10
Vetted Review
Verified User
  • Report Generation: Flexible, Extensive, Customizable and accurate
  • Custom Filtering: Very much useful when you are dealing with a huge data and you need multiple filters in place. You apply a filter and all the worksheets connected are updated with the filters. Amazing.
  • Integration: Seamless integration with MS products such as SQL Server and Azure.
  • Fix the UI Please: The UI is far worse as compared to clean UI of Adobe Analytics and Tableau. It still feels like you're using a very old software
  • Make it more fast & quick: Still takes some time if there is a lot of data - sometime even makes some error.
  • Add more visualization: Still lacks some very niche visuals which we might require basis the data-type
David Shi | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Incentivized
  • Excel integration, allowing users more familiar with Excel to transition over with relative ease.
  • Inexpensive license model, compared to Tableau which can get very expensive depending on your needs.
  • Updates, by far Power BI is one of the most updated apps currently. With monthly releases of new features and fixes.
  • Poor interface, not as intuitive as Tableau and very typical of Microsoft where it can easily get you 80% of the way there, while getting the last 20% is seemingly impossible.
  • Not enough flexibility in formatting, whereas in Tableau getting something to look 'pixel perfect' takes a lot of effort, in Power BI in a lot instances 'pixel perfect' is not even an option given the lack of controls in formatting.
  • Reliance on Excel means data related best practices are naturally hindered by the kind of 'dirty' data that is typically used in Excel as opposed to cleaned up tables sitting in data warehouses.
Scott Kennedy | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • Ability to crunch large volumes of data
  • It has a ton (and growing) number of data source connections
  • The visualization opportunities get better each month
  • The cost model could improve for the premium tier
  • Power BI desktop of a VM is pretty cumbersome
  • Power BI desktop doesn't work for Macs
Score 9 out of 10
Vetted Review
Verified User
  • Create workspaces for the assigned data source with security
  • Publish and share data across team members
  • Publish embedded reports within a given URL or web portal.
  • The new UI should be simpler to view from an admin side of view.
  • The gateway servers within power bi gateway management should be moved to the previous view for better administration. However, the current new view is different but better enhanced
Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • ETL tool query editor gives one of the best data cleansing tools inbuilt into the Microsoft Power BI desktop.
  • It has more than 200 plus visuals in store and use.
  • It has great user community.
  • It has ample amount of training videos for users to learn.
  • It is very cheap BI tool in Market.
  • Visual Formatting should increase by giving more easy to use option like Excel.
  • Page level security should be expected.
  • Cell merge is required to show heading in visuals.
April 25, 2022

Review for Power BI

Score 10 out of 10
Vetted Review
Verified User
  • Data Visualization
  • Integration with other Microsoft office app i.e Excel
  • User Interface is Easy
  • Sometime it is hard to work with non Microsoft Applications
  • Compatibility issues With Mac
  • Leaning curve
Score 9 out of 10
Vetted Review
Verified User
  • Deal with different sources at the same report (CSV, Excel, SQL, etc).
  • Easy to load and refresh the Data.
  • How that data is displayed in a visual, is super easy and fast to do it.
  • Easy to add new visuals other than the built-in ones.
  • Make a way for multiple people to collaborate in the same file.
  • Create a tool that you can design and create your own visual.
Afia Tamanna | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
  • Quickly filter and view granular data sets with easily configurable reporting figures.
  • The ability to quickly switch between tabs allows for historical data comparisons and progress tracking.
  • It's helpful to dive into the data and break it down from high levels to small.
  • Achieve actionable insights faster by using real-time data. It's incredible to have online access to reports.
  • The pricing model for the premium tier has room for improvement and a learning curve.
  • One must have a solid data analysis background to use Azure integration in some configurations.
  • Power Query is unnecessary and can be replaced by database queries and procedures.
Colin Sebastian | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Manage data
  • Import data
  • Publish to Teams
  • Aggregate information from many sources
  • The load time could be shorter
  • Better connections to non Microsoft sources of data
  • Easier to use and manipulate data already in BI
Suryaprakash Mishra | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
  • Quick real-time information
  • Streamlined publications and distribution
  • Row level security and element of machine learning and AI
  • Ability to connect to SAS datasets
Blake Baron | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Easy to slice and dice data.
  • Familiar theme for those familiar with other Microsoft products.
  • Integrates with SharePoint & OneDrive to easily share intelligence across the team.
  • It's intimidating for first time users.
  • It's "heavy" in that it takes up a lot of processing power.
  • Of course, it's only as good as the underlying data.
Score 10 out of 10
Vetted Review
ResellerIncentivized
  • Easy to setup and develop solid reports
  • Supports a substantial number of data sources to import from and connect to
  • Great reports designer with many chart types and customizations
  • Intuitive interface
  • Desktop and Pro versions are reasonably priced
  • The desktop app is great but needs a lot of performance improvements
  • No MacOS Version for the Desktop app, this is a big limitation for business since executives prefer Macs
  • Premium Cloud Version of Power BI is awfully expensive
  • On-Premise Version of the Power BI Reports Server is bundled only with SQL Server Enterprise License and cannot be purchased separately and requires Software Assurance Subscription
  • On-Premise Power BI Report Server doesn't support ADFS, AzureAD or any Claims-Based authentication platform, a sad disadvantage for enterprises
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Microsoft Power BI is great for creating reports and charts for data visualization
  • It can integrate very easily with excel and SQL server database
  • It is easy to learn and use
  • It is cheaper compared to other options
  • It can sometime take a long time to load the data
  • Not enough options to share dashboards externally
  • Custom visuals are not easy to configure and manage
  • DAX can be difficult to understand and write
May 15, 2021

Microsoft Power BI

Score 7 out of 10
Vetted Review
Verified User
Incentivized
  • Data connects many other products
  • Easy to manipulate data to suit different uses
  • Very robust, yet still easy to navigate
  • Sometimes the web app version moves slowly or doesn't seem to update effectively
  • There is some functionality only available in desktop version
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • Interactive tool with great user interface
  • Different types of visualization possible
  • Custom reports can be created
  • Not self learning tool
  • A small change in one input file, can have huge impact on the report and it is very difficult to test it
  • Need to learn coding for advanced reporting
Return to navigation