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

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

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

Access Control and Security

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

8.2
Avg 8.5

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

(1777)

Attribute Ratings

Reviews

(1-25 of 72)
Companies can't remove reviews or game the system. Here's why
Score 8 out of 10
Vetted Review
Verified User
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 BI does an amazing job handling Big complex data. The visualization, customization, filter and DAX options are really very flexible and helped me to prepare a great overall analysis.
The UI lags a bit sometimes as compared to other BI tools like Adobe Analytics, Tableau and others but the Microsoft Power BI is a powerhouse in terms of data processing and hence a great tool to have when you're dealing with Big data. Since Microsoft provides other integrations to its Cloud service Azure - it was fairly compatible for us to use Azure, Microsoft Power BI, SQL Server in sync. Overall a great product.
  • 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
Where it is well suited - If you want to do Big Data Analysis, want to do it extensively, want it on the cloud and data-base support. Microsoft Power BI can be the best option as it comes with seamless integrations of MS products such as SQL server and Azure. Also handles large data effectively.

Where it can be a problem - If you want elegant looks graphs, white label reports, budget issues, then, in my opinion, don't go for it.
Mohamed Adil Shaikh | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Power BI is a great tool for Visualization and reporting.
We basically use this tool as a means of analyzing the maintenance data base in SAP.
Because of this tool we can easily be able to find out the insights and bottle necks in the SAP Data.
With Certain filters and query this dashboard can be easily shared to the higher management and can be able to find out where to improve by quickly analyzing the data.
  • Visualization
  • Charts
  • Dynamic Charts
  • Queries and filters
  • Dashboard should be easily sharable
  • Online Editing should be possible without downloading the app.
For finding insights of huge data sets, where automatic cleaning and processing of data is required before creating charts and dashboards, there the software is well suited.
Where data keeps uploading on a regular basis and it needs to be shared with a team and all the team members are involved in updating the datasets and charts, so it becomes difficult to manage.
Subhodeep Chandra | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Microsoft Power BI helps in building various visuals from different sources like databases such as Excel and Azure. Currently, we are working on data visuals for one of our clients using the Azure database.
  • Great visualization
  • Can be opened from mobile and desktop and anywhere
  • Can be linked with many sources
  • User friendly UI and its AI is very helpful
  • Can allow data upload more than 2GB
  • Can allow data export for unlimited number of rows in Excel
It's very much suited for data analytics and not suited for support projects.
David Shi | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Incentivized
[Microsoft] Power BI is currently used as an alternative to Tableau, with its lower cost and more robust built in modelling, ETL functionality and familiarity for users used to the Microsoft stack. As an alternative to Tableau in the organization, it is currently deployed on a very limited basis as Tableau is still the preferred platform for creating dashboards across the majority of the organization.
  • 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.
For any instance where Tableau is too expensive as an option, [Microsoft] Power BI is the natural choice. Also in cases where the end user is operating in a Microsoft stack heavy environment where they're expected to perform both the data modelling and wrangling as a data engineer type role, along with the actual creation of dashboards in a data vis and dashboard reporting developer type role.
Score 9 out of 10
Vetted Review
Verified User
Reporting BI tool for the entire organization for Intact. In the past, many Power BI dev. didn't have unique and secure workspaces to share and collaborate their reports and data. It was also stored in an unsecured manner and its location is many. Power BI gateway services and power bi web services with a premier license model provided us the solution to separate, secure, and manage the reports and their data governance around them.
  • 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
Microsoft Power BI Premium License is an excellent model for companies requiring multi-geo locations to keep their data and workspace separate due to regulatory reasons. In addition, the licensing model - Power Bi also has a great feature to connect to on-prem databases and cloud-based PaaS data sources.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
There are a lot of manual reports with the same activities in daily, weekly, and monthly frequency of various reports. It can automate the reports to reduce TAT In this have benefits of both ETL tool and visualization with more than 200 plus visuals in store. We are using SQL server for database and later connect to Microsoft Power BI after development publishing to service for clients. Will connect gateway for automatic refresh.
  • 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.
Query editor is best in all parts of this tool. It has more than 200 plus visuals to impress the clients with that. Microsoft Power BI service has 10 GB of data storage for pro users this will give developers can store more reports and data. It has an ample amount of data sources that can connect and develop the reports.
April 25, 2022

Review for Power BI

Score 10 out of 10
Vetted Review
Verified User
We use Power BI for data presentation and Visualization of the data as we know raw data is nothing we use Power BI to clean and present data and derive meaningful information. It is very easy to use and if you are using Excel then the user interface is very similar to it.
  • 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
When we are cleaning data and making reports and creating meaningful data from raw data and generating report, visualization of data to other stakeholders it is very useful application but some time using with non Microsoft apps it is not supported i.e Desktop version on Mac so not recommended for Mac.
Score 9 out of 10
Vetted Review
Verified User
We are using Microsoft Power BI widely in the Company, together with more than 80 associates were are the Gurus of Power BI, we help people to develop their own reports. Using Microsoft Power BI really facilitate and make the data showing easier, in the old days we used to create a report on Excel and they send this to a lot of people or copy and paste the info on PowerPoint and then share it across many teams. But now we use Microsoft Power BI to load a lot of different source data points (CSV, Excel, DB, etc), combine and enrich this data and then publish the report into Microsoft Power BI Services and from there we share the list across the teams. We have some reports that are being used by more than 800 people. Microsoft Power BI definitely was a step up on how the data is consumed. The only big problem that I see is that some users don´t have the full knowledge about it making it now well developed or organized resulting in a heavy Report that takes longer to load.
  • 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.
I believe Microsoft Power BI is one of the best tools in the market and because is from Microsoft it fit in all the other applications from Microsoft. Every application has room to improve but the built-in feature and all the possibilities that open make it one of the best for sure.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Power BI is a perfect platform for us in order to display the data in an useful and interactive way.
Before starting to use Power BI, there were a lot of work needed for some meetings (as you had to do same slide for all the possible scenarios) and there were not much flexibility during the discussions.
Now all the flexibility can be addapted during the conversations, making faster and clearer decissions as you can visualize everything with a couple of clicks.
Also it is superflexible in terms of connection to different data providers, so you can combine a lot of information from various places in just one dashboard.
  • Data visualization
  • Flexibility
  • Different data connectors
  • Speed when big volumes of data
  • Selflearning from the data
In operations we use the tool for many different topics, from factory quality systems to high level reviews.
We have created kind of an internal "App Store" based on Power BI where you have a lot of different dashboards for different solutions (cost, cash, health and safety, sales, factories, distribution centers...) and you as an user just need to get in that "App Store" and enter in whatever tool can be useful for you. It is open to all the operations employees and can use on demand.
Also it has raised the imagination of our colleagues, as they are not only working by themselves creating new reports, but also raising fantastic ideas that can be extended for the usage of all the community.
Colin Sebastian | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use Microsoft Power BI for any number of tasks, mainly synthesizing data down and making easily to read and use charts. It's also used to view lots of data in a reasonable manner and view changes quickly. Additionally, we use it for management presentations to executives for business status updates.
  • 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
It is best suited for taking lots of data (spreadsheets or other) and producing visually appealing content. It is also helpful for coming up with visualizations that can be regularly updated and used for executive status presentations and other management reports. Finally, it is good for functions where excel can not keep up such as intricate drop down, selections menus, sliders, etc.
Suryaprakash Mishra | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Currently, the product is used by [a] few teams including my team. The organization is developing [a] Data Analytics platform and then [Microsoft] Power BI will [be] used [in the] organization moving forward.
  • Quick real-time information
  • Streamlined publications and distribution
  • Row level security and element of machine learning and AI
  • Ability to connect to SAS datasets
Data visualization and insights via [Microsoft] Power BI for [the] public version of Dashboard.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
MS Power BI has been used in my company as a visualization tool along with QuickSight and Tableau. They all serve the same function that is interactive plots that can be saved and shared with others. Depending on which department it is, the team choose one of these options based on the data sources.
  • interactive
  • connectivity
  • easy to learn
  • costly
  • analytic
  • pipeline
I would recommend the MS power BI to colleagues who don't have coding skillset or to someone who wants to have interactive graphs to share with other colleagues. For people with strong coding ability, some python/ R packages can do that trick easily without the need for the premium fee.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
The platform is easy to use and has a quick learning curve. Easy to create reports and bring in different data sources. It gives you the ability to export to cloud quickly and easily.
  • Analysis and presentation of data
  • Report generation
  • Simple and effective GUI; easy to learn
  • Few customization options
  • Icons are small and hard to read at times
  • Handling of complex relationships between tables could be improved
Microsoft Power BI allows you to manage, organize, and visualize data in a more efficient way. Microsoft Power BI's integrated tools make it easier to create models, analyses, reports, and predictions. Microsoft Power BI gives you a more attractive visual appearance.
Blake Baron | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Currently, it's only being used by our division for internal reporting usage on our sixteen members to leadership. Leadership can view progress and be alerted to new activities our team has to work on. We use it for weekly reporting on the status of various analyses and how much value is at risk as a result of them.
  • 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.
It's good to use if you have at least one power user (pun not intended) and the enterprise resources to back it up. It's not as visually appealing as something like Tableau, but it allows an audience to filter complex data sets based on pre-set criteria in a controlled environment.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Power BI is our visualization tool to make our data insightful and easy to digest. Power BI is nice because it builds on your Microsoft Suite of applications and is easy to use. Power BI helps create standard views for high-level insights, with the capability to drill down. A drill-down capability is a powerful tool for actionable insights.
  • Actionable insights
  • Subscriptions for scheduled reports to your email.
  • Easy to use with different types of data sources.
  • Manipulating standard views can be more challenging for less experienced users.
Since Power BI is a data visualization tool, it's useful anywhere a standard report or visualization is required. I like to use Power BI, especially where you want to avoid inconsistent manipulation of data to produce insights. Taking this process out of the analysts' hands ensures data consistency and avoids the question of whether data can be reliably used. It keeps one source of truth.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Power BI was is being used as a data visualization tool and for creating dashboards across the complete organization. All stats based reporting is now being done through it as it is easy to slice and dice through it in an interactive and easy manner. It also allows to drill down to next level of analysis.
  • 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
Suited when different type of visualizations is needed; need to be shared with multiple users including external users; need slicing and dicing; need drill down capability

Not suitable for simple visualization as MS Excel pivot tables are equally good with less hassle and effort.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Microsoft Power BI is used by the entire organization for basic analytics and data visualization purposes. It enables the functional users without technical background to quickly customize their reports as per the requirements and even share the reports as well as the insights from the reports with other users in the organization. Also, the information can be analyzed and visualized in the real-time making sure that actions can be taken based on insights in due time.
  • Data from multiple sources can easily be imported and processed using in-built connectors in Power BI.
  • Auto ML capabilities are inbuilt helping people create predictive models without an in-depth knowledge of coding and algorithms.
  • Reports and dashboards can be accessed on the go via mobile apps.
  • Learning to create dashboard on Power BI is a bit intimidating for a new user and takes a long time to learn different functionalities.
  • Documentation is not great and links are broken at times.
  • No support Mac based devices.
Microsoft Power BI is suited for teams with a lot of reporting and dashboard creation requests as it gets the job done even though the learning curve is steep. It is also suited to the situations where data is scattered across different platforms and tools and needs to be combined to generate reports and insights.
Alex Brielmann | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Incentivized
[Microsoft] Power BI was used at Conga mainly as a data visualization tool, while also using it as a repository for data from multiple systems. We used Snowflake to combine data from different systems and then housed everything in [Microsoft] Power BI. We could use data pulls to put together our weekly board deck, as well as to simply provide simple charts for all different teams throughout the entire sales process.
  • It's ability to store massive amounts of data allowed it to be a useful resource for multiple teams
  • Multiple different charts and graphs were available, making it far more visually stimulating than Salesforce native functionality
  • Data pulls are seamless and show up in easy formatting
  • A slightly clunky user interface, makes most end users fear building anything themselves
  • 3rd party api syncs seem to be a pretty heavy lift to set up
  • The overall set up when building a report is intimidating, and some buttons aren't clear, so hovering over all of them to see their labels can be time consuming and annoying
[Microsoft] Power BI seems to sit slightly in the middle of the road as a data aggregation and visualization tool. It has the look and feel of an old tool that should be mastered by now, but it's output does not seem to match that. Our team had to constantly fix errors and bugs, which is not what you are looking for from a tool coming from Microsoft. On the other side, it isn't as user friendly or pretty as a tool like Domo. It somewhat lies in the middle on both functionality and user experience.
April 30, 2021

The Industry Standard

Score 9 out of 10
Vetted Review
Verified User
Incentivized
Microsoft Power BI is used by various teams across our organization to compile data into easy to read reports and metrics. Specifically, my use with it is related to portfolio and project management. We use it to create a 'placemat' type report to show the full technology portfolio to our most senior leaders at the organization.
  • Dashboards
  • Summarizing Data
  • C-Level Ready Reports
  • Requires some training
  • Not very user friendly on the input side
  • Requires developer skills
Microsoft Power BI is very useful to congregate large data sets in a concise, attractive way to share with senior management. It can be automated with data queries to pull in databases and refresh on a regular cycle. It's great for scenarios where you have regularly changing data being driven by another tool. For example, we use Clarity PPM to push data into Power BI.
Luciana Montivero | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Power BI is used in my organization only in the analytics and biostatistics team, within the medical informatics department. We mainly use it to easily integrate our different databases information into a one-only report. As it's easy to use, it helps us deliver complex and clean metrics truly fast, and as we work in the health industry time is a big factor to take into account (especially during a pandemic).
  • It's an excellent tool to integrate tables from different databases into one report.
  • The visual indicators are mostly complete and easy to use.
  • You can edit/manage/transform your tables to do almost whatever you want.
  • The UX is clean and simple, but powerful enough to deliver great results.
  • When you get too many tables, it might get a bit slow, it would be great if it could be more performant.
  • There aren't as much statistic tools or add-ons as one would want. Now, you can only do descriptive analysis but if you wish to do statistical tests there aren't functions or integrations that help you easily do that.
  • Formatting of some elements is a bit limited.
  • Sharing a dynamic report is not as smooth as I would like (to do so you need to pay for a license for the visitor or give access to your information to Microsoft, which I legally can't do).
  • The integration with R is not as good as I would like, it has many issues with the imports and the versioning of R and its packages.
I think Power BI really addresses the goal of what it was meant to do. It has a powerful interface, an easy integration with most data sources, which makes it easy to just import some information and start playing with your data. If you want a fast, powerful data analytics tool or a control panel to show fast reports, this is the tool you need. You'll be amazed at how easy it is to add a SQL-powered data source, add some visualization tools, and then just try different things! It's a truly complete and intuitive tool that will help you take real advantage of all the information your company does.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
My company uses Microsoft Power BI throughout the organization for daily reporting tasks as well as analysis. One of the major projects we did using Power BI is to identify the services which are taking more than 2 days to complete (typically is should be done within 48 hours). This helped us to reduce the overall costs for business.
  • It excellently manages the relationship connections between tables.
  • It is easy to transform the data using power query.
  • Power BI lets you connect to multiple data sources at the same time.
  • Using DAX formulas helps you to create new measures using existing fields.
  • Power BI could have more charts and visual representations.
  • Easier way to manipulate the data.
Best suited for daily reporting purpose. It is very user friendly so people from non technical background can use it. Also the drag and drop feature helps to check the different scenarios. It also helps to connect directly to R scripts.

Less appropriate scenario would be when explaining through different graphs, it doesn't have a lot of options to choose from.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We currently use Microsoft Power BI across our whole organization to for visualization and trending of product data. It addresses the need for automated dashboarding of data and the ability to quickly filter and access trends that are occurring without the need to manually query and plot the data by interested individuals.
  • Nice dashboarding capabilities.
  • Can integrate well with other Microsoft products.
  • Calculated fields.
  • Connectivity to data sources.
  • Some small bugs/constraints on how data visualization components.
  • Some components of Power BI dashboards are a bit clunky and outdated.
  • Iterating/versioning of dashboards not seamless.
Well suited to scenarios where you're connecting to data sources such as MS SQL Server and need to be able to automate the display of data under a common set of repeatable filters and plots. Also great for organizations already within the MS ecosystem since you can integrate with MS Teams, etc.
Less well suited if you need more flexibility and dynamic changes around your visualizations. MS Power BI dashboards are more rigid and less suitable for cases where you want to use the dashboard to dynamically drill into your data and slice it multiple ways quickly.
April 27, 2021

Do try PowerBi !

Ilektra Skepetari | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
I used [Microsoft] Power BI to create and share dashboards with analytics and graphs across different areas of the business. It makes sharing data easier and provides customizable visualizations that are easy to create even without technological background. Most importantly, it is easy to load great amounts of data as it is very easy to connect with azure data sources.
  • Visualizations
  • Data loading
  • Data manipulation
  • Can be slow
  • Premium/pro licence required to share dashboards
  • DAX language required for more complicated queries
If a certain company is already using Microsoft cloud services, [Microsoft Power BI] is a life saver. It is extremely easy to load data sources from Azure and then the simple data manipulations provide very insightful charts. However for very complicated manipulations it can be quite slow - in this case the automatic background data refresh is necessary.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We have several departments across our organization that use [Microsoft] Power BI. It helps us aggregate data sources and better understand (visualize) the data when the source systems do not have these capabilities built in.

[Microsoft] Power BI allows us to easily create visuals and share findings with others across our organizations.
  • Data aggregation
  • Data visualization
  • Data consolidation
  • Initial user interface can be hard to navigate
  • Would like to see more suggestive visualization recommendations, similar to how PPT provides design ideas
  • More color schemes / options for design
[Microsoft] Power BI has helped us consolidate multiple data points from excel into clean visuals to explain complex data into visual storytelling.

In one example, we had website inventories from over 25 websites that we consolidated into one summarized view, breaking down page types, format types, template types, etc. all into a clean set of visuals.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
The organization is currently shifting from Tableau to Power BI as its primary BI visualization tool. This began as parallel efforts both by IT to decide to make the switch due to the value proposition, as well as in some business units which had begun to use the tool for their own data needs.
  • Very intuitive to use, particularly if you have a background in Excel and have leveraged Power Pivot.
  • Excellent visuals with a wide variety of options.
  • Great performance, driven by the same engine used by SSAS Tabular.
  • For on-prem users of Power BI Report Server, it would be useful if Desktop included a compatibility level that could be set rather than having to manage desktop installs, particularly with the app-based installation option.
  • Formatting options can be uneven between different visuals.
  • Formatting for tables based on queries seem to randomly be reformatted to being difficult to read.
Power BI is an excellent choice for any company looking to get into the Visualization space, or considering a change or supplement of existing BI tools. With both cloud-based and on-prem versions available, delivery methods fit with any on-prem, hybrid, or cloud-based approach. Obviously, from a cloud perspective, this would lend itself better to companies with an existing investment in Azure. The desktop tool provides an easy-to-use experience that will be familiar with advanced Excel users. This allows power users in the business a faster track to develop data models than many other tools. The visualizations are at least on par with other top tools, and the open source nature of developing visuals has led to a rich marketplace providing additional capabilities. There is a reason Power BI is leading in the Gartner Magic Quadrant.
Return to navigation