Microsoft Power BI Reviews

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
651 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Do you work for this company? Manage this listing

TrustRadius Top Rated for 2020

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Filtered By:

Reviews (1-25 of 91)

Richard Crane | TrustRadius Reviewer
September 30, 2019

Power BI is So Easy and So Good

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Reporting, reporting, reporting. Power BI is great for reporting. I can create a number of different charts, views, and dashboards for a number of different audiences. It's very helpful for executives to see the big picture, but dynamic enough to take the same data sources and create detailed reports on very specific elements.
  • Power BI is easy to use. We went from manual data entry and report creation in Excel to Power BI. There was a learning curve, but I was able to find enough training online to get started.
  • Automating the report creation is wonderful. It takes all the manual work out of my old daily processes. My supervisors and bosses have been impressed too. They think it's magic, which makes me look good.
  • I can't automate a data source if the source requires a login and password to get into the resource. In the past we got around this issue by having vendors email us an exported .csv file, but for some sources that doesn't work. Maybe there's a better solution for this, but I don't know what it is.
  • There are still some more advanced features that I'm trying to figure out, like machine-learning type of reports. It's not quite up to that level of reporting, but I also think if I had more skills or creativity i may be able to figure it out. Just need some more time with it.
Read Richard Crane's full review
Rick Botha | TrustRadius Reviewer
September 26, 2019

Beautiful Reports and Useful Data, but configuration is not easy!

Score 6 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Engaging dashboard displays with drag and drop modules to convey data in a meaningful ways.
  • Familiar Microsoft "Ribbon" type interface that creates an integral feel with the rest of the Microsoft suite of products.
  • Built-in mobile optimization window and associated Mobile applications that allow viewing from any location connected to the server.
  • Initial creation of reports, even from processed data sets is not simple.
  • The on-premises reporting (crucial for a defense industry company) is extremely expensive, as it is only included in the Power BI Premium package.
  • User training is usually required to ensure that full functionality of the dashboards and their built in features are utilized.
Read Rick Botha's full review
Steffany Winkelmann | TrustRadius Reviewer
September 25, 2019

Power BI - Excel on Steroids and So Much More

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Beautiful graphical models of your data
  • Fast processing whether you're working with local data or pulling it from your database
  • Very easy to share reports within your organization
  • Surprisingly fairly easy to learn
  • It is such a powerful system that it can come across as intimidating for some without some Excel knowledge
  • I'm not a database analyst or administrator, so calling the data in can be difficult (not necessary the fault of the software, but something that could be difficult for teams without someone with database knowledge)
  • It can come across as confusing, when there is both a local Power BI and online Power BI components. They don't necessarily do the same functions. You'll definitely want to know how to use the online version as this is how you'll publish and share the results of your findings, but the local one has a lot of capabilities that don't appear to be directly available in the online version (and if so, it's not immediately apparent).
Read Steffany Winkelmann's full review
Shreshthi Mehta, PMP®, PHR® | TrustRadius Reviewer
December 09, 2019

Simplified metrics using Power BI

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Saves time as regular reports do not need to be created every time.
  • The tool has several grafts and charts that can be created by the click of a button.
  • It is easy to analyze data by dwelling deeper in each data set.
  • Can be interfaced with several systems.
  • The system is useful in data analytics but there is a learning curve.
  • It is difficult to understand the linking of datasets while organizing data in the beginning.
  • You need to work with an IT person to interface Power BI with existing systems.
  • While the tool runs the required metrics, it does not tell a story to connect all the metrics. Human intervention is required in this phase.
Read Shreshthi Mehta, PMP®, PHR®'s full review
Guillermo Villamizar | TrustRadius Reviewer
September 15, 2019

Power BI: Great solution for reporting and dashboards!

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Reports and dashboards complexity were greatly reduced.
  • Easy drill-down on selected information.
  • Different types of views for the same information.
  • The licensing cost might be a little high for some companies.
  • It consumes a lot of resources.
  • It's not very user intuitive on first use.
Read Guillermo Villamizar's full review
Chris Widner | TrustRadius Reviewer
September 13, 2019

Look like a genius with your reports with PowerBI

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Easy to create beautiful charts that make the data very easy to understand.
  • Ability to quickly add/remove certain contracts from the dataset and see the differences with and without these contracts.
  • Mobile view is really nice too!
  • Can be difficult to import certain data sets like MySQL that is on-prem.
  • Takes a bit of getting used to using. Once you're using to it you look like a genius with how fast you can create reports.
  • Pricing can become a bit much at scale.
Read Chris Widner's full review
Che Odom | TrustRadius Reviewer
September 17, 2019

Power BI is a great reporting tool, particularly for leadership teams that don't want to dive deep, but want accurate and timely information presented to them to make choices

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Data retrieval/mining
  • Data presentation/visuals
  • customization
  • Ease of use - this tool could be much more intuitive in its design
Read Che Odom's full review
Anonymous | TrustRadius Reviewer
January 21, 2020

Power BI: Best BI tool for companies that use Microsoft products.

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Importing data sources: Very intuitive way to import data, with pop-up wizards to guide the process.
  • Creating charts and graphs: It is possible to create charts and graphs just by dragging data fields, no programming required.
  • Power BI online is still very limited and also requires that every user has a pro license to see published dashboards.
  • If you need to make advanced changes to the imported data, it is required to learn the M-Query, which is a Power BI programming language.
Read this authenticated review
Anonymous | TrustRadius Reviewer
August 09, 2019

A great tool for the analyst's toolbox and for sharing reporting within a team or department.

Score 6 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Data blending from several different files is a big hit with our Power BI users. We have so many excel and CSV files and many of them are not clean, so making use of the data cleaning and blending saves us from countless pivots and lookups to just get data worthy of analyzing.
  • The visualizations are top notch, and available without additional cost. Everything is in vibrant colors and crisp, clear lines that whatever your produce is clearly pleasing to the eye. From mapping down to pie charts, the visuals are well done.
  • The Beta preview is very helpful, not all software allows you to preview or use things in beta, but Power BI has a wonderful set of tools and visualizations you can add into your work with very little effort or complexity.
  • Power BI lacks in horsepower compared to other tools with more robust ETL components built in. Particularly if you connect to any type of source system database like SQL, you have to either have a SQL View built for you that limits the volume of data your bring in, or have solid knowledge of the SQL table structures to build yourself custom (and correct!) connections to the tables.
  • Security is not as robust as other BI tools, like Qlik Sense. We often need to restrict subsets of data by customer and even functional position of an individual within a customer. Power BI’s security seems to be built for using just within a company, so if you leverage your work outside the firewall there can be issues when figuring out security streams.
  • I do not like the pricing. It’s really a dirty trick, Microsoft goes around and says the product is free. Well, the stand-alone is free, yes, but you have to pay for the “enterprise” version so you can share files. They say it only costs $10 a month/user, which again is a white lie. You need much more IT infrastructure and people to build SQL views and Tabular Models so you can use the tool, and Microsoft does not tell you that. So we find it is a good stand-alone tool to analytics, but a fairly heavy cost structure if you roll it out enterprise-wide as compared to Qlik or Tableau (which are more expensive per license, but require less back-office support).
Read this authenticated review
Anonymous | TrustRadius Reviewer
November 15, 2019

Nice dashboards and easy to adapt when you know Excel.

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • It has a free version offered with Microsoft Office 365. So businesses with this type of license can enjoy it free.
  • Good dashboards, auto calculation and database connection capabilities.
  • Easy to learn and use when you have familiarity with Excel. You can reach free training material on many platforms.
  • Well integrated with other Microsoft programs (Excel, Access)
  • Expensive if you want on premise version. Choose the best fitting license.
  • There are some functionalities that require detailed learning. You need to have good experience with Excel, database connections, DAX.
  • Data quality matters. If you have uncleaned data, then your work on Power BI can be frustrating as it is poor on providing suggestions.
  • You may encounter with performance issues when your data is big.
Read this authenticated review
Anonymous | TrustRadius Reviewer
October 01, 2019

Great software for data visualization

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Connect to various data sources (online and offline)
  • Ease to use and start training with no cost
  • Best feature is to create template report and refresh it with new data every month
  • Connection to SAP Business Warehouse or Oracle needs additional add-ons
  • It's like Power point, difficult to put all charts in the same size or put in one line
  • Can only insert 1 online data source at a time. If you have 1 online data source, cannot add additional sources in dashboard
Read this authenticated review
Anonymous | TrustRadius Reviewer
September 15, 2019

King of Self Service Business Intelligence

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Microsoft Power BI is the best value for money, self-service business intelligence tool available in the market. It is intuitive to use and comes with a library of data connectors.
  • It has fantastic data visualization capabilities and simplified user interface.
  • We store most of our data on the Azure data lake and Power BI works seamlessly with it.
  • Most of our users prefer the desktop version compared to the web tool. Microsoft should put efforts into making the web tool robust and easy to use.
  • The refresh cycles are less if you opt for the free version. We bought an enterprise edition to get over this.
  • Free versions have less storage and are slower.
Read this authenticated review
Anonymous | TrustRadius Reviewer
September 15, 2019

Really Great!

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Correlation.
  • Presentation.
  • Visualization.
  • Dashboard customization.
  • Sharing.
  • Agility.
Read this authenticated review
Anonymous | TrustRadius Reviewer
September 14, 2019

Strengths and Weaknesses of Microsoft Power BI

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Free license and tool is available in Microsoft office as an alternative to expensive tools in the same field
  • Flexible to connect with multiple data sources and ERP systems
  • Training modules are available for users with good detailed explanation
  • Can publish review online for yourself and team-members and executives
  • Multiple layout for visualization
  • Editing data is bit difficult -- it requires dataset to be formatted in a particular manner, otherwise it will give errors and the user will end up most of the time in fixing the issue himself.
  • Everytime data is required to be refreshed, which leads to the issue of regenerating the visualization
Read this authenticated review
Anonymous | TrustRadius Reviewer
September 13, 2019

PowerBI is a great tool

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Easily load and integrate data from multiple sources.
  • Integration with Office 365 is smooth.
  • Same user Interface as other Microsoft tools so the learning curve is lower.
  • Lots to do and thus it is hard to be aware of all it does.
  • Updates often so hard to keep on key developments.
  • Sometimes data migration takes time.
Read this authenticated review
Anonymous | TrustRadius Reviewer
November 19, 2019

Microsoft Power BI - Easy Analytics

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Drill down to lower-level data
  • Visualize performance trends
  • Ability to join data from different sources
  • Improve geographic map visuals
  • Need SQL query editor
  • Write custom python code
Read this authenticated review
Anonymous | TrustRadius Reviewer
September 13, 2019

Microsoft is one of the best tools for Data Analysis

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Lot of Packages available to represent the data
  • Predictive and Visualization representation are very useful
  • Lot of users are implementing new packages and share the same with users which helps in find quick solution to our requirements
  • Open Source community as well provides help in case of any issues or solution needed
  • Issues with finding a central repository to find out the implementation of packages
  • Search more needed for finding the details of any package, for example, any package need to search a lot to find out the details
  • Tutorials for beginners to explain the navigation and details
Read this authenticated review
Gabriel Oliveira | TrustRadius Reviewer
July 06, 2019

Microsoft Power BI review: A way to optimize and improve visualization

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Similar to office 365 applications such as Excel and Access, that is, it facilitates the usability of those who already have advanced knowledge of these tools.
  • Optimal ways of presenting data.
  • Data collect.
  • Control panel.
  • Sometimes the table relationship is not no simple to set up.
  • Certain elements are very limited, in the visual part mainly.
  • The tool is unnecessary in relation to the panel interface compared to Tableau.
Read Gabriel Oliveira's full review

Feature Scorecard Summary

Pixel Perfect reports (77)
8.1
Customizable dashboards (91)
8.6
Report Formatting Templates (83)
8.4
Drill-down analysis (91)
8.6
Formatting capabilities (90)
8.4
Integration with R or other statistical packages (65)
8.4
Report sharing and collaboration (88)
8.8
Publish to Web (84)
9.0
Publish to PDF (75)
8.5
Report Versioning (63)
8.5
Report Delivery Scheduling (62)
8.6
Delivery to Remote Servers (43)
8.2
Pre-built visualization formats (heatmaps, scatter plots etc.) (84)
8.6
Location Analytics / Geographic Visualization (77)
8.5
Predictive Analytics (64)
8.0
Multi-User Support (named login) (75)
8.6
Role-Based Security Model (62)
8.4
Multiple Access Permission Levels (Create, Read, Delete) (68)
8.6
Single Sign-On (SSO) (48)
9.0
Responsive Design for Web Access (73)
8.4
Dedicated iOS Application (55)
8.2
Dedicated Android Application (59)
8.3
Dashboard / Report / Visualization Interactivity on Mobile (73)
8.3
REST API (41)
8.3
Javascript API (32)
8.5
iFrames (33)
8.1
Java API (27)
8.0
Themeable User Interface (UI) (36)
8.4
Customizable Platform (Open Source) (26)
8.3

About Microsoft Power BI

Microsoft Power BI is a business analytics service 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.

Key features

  • Free initial setup with no required training
  • Connectivity with Excel spreadsheets, cloud services, streaming data, on-premise databases, and more
  • Dashboards that update in real-time
  • Natural language processing for data visualization tools
  • Shareable reports and datasets
  • Collaborative framework
  • Remote accessibility
  • Integrates with most applications and services using REST API
  • Publish data directly from service with publish-to-web feature

Microsoft Power BI Technical Details

Operating Systems: Unspecified
Mobile Application:No