What users are saying about

Microsoft Power BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Top Rated
351 Ratings

Microsoft Power BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Top Rated
351 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.1 out of 101

Add comparison

Likelihood to Recommend

Microsoft Power BI

Power BI is great for power Excel users and what I call “data archeologists” or people who dig up old data and clean it up for modern usage. It strings many files together and lets you customize the connections and format of the data. It does not work well with large data set or pull data from large databases, you will find it timing out unless you limit the data set first with a SQL View or Tabular Model before going after it. Also, large data sets take forever to refresh and update, so if you have a lot if iterations, you will spend a lot of time going out for coffee while the data reloads. Other BI tools allow you to localize the data with the first load (Qlik QVD’s) so you can refresh quicker. Comparatively, a refresh of SQL data on Power BI took 45 minutes, the exact same data set would refresh in 30 seconds using Qlik Sense.
No photo available

Feature Rating Comparison

BI Standard Reporting

Microsoft Power BI
8.0
Pixel Perfect reports
Microsoft Power BI
7.7
Customizable dashboards
Microsoft Power BI
8.4
Report Formatting Templates
Microsoft Power BI
7.9

Ad-hoc Reporting

Microsoft Power BI
8.2
Drill-down analysis
Microsoft Power BI
8.5
Formatting capabilities
Microsoft Power BI
8.1
Integration with R or other statistical packages
Microsoft Power BI
8.0
Report sharing and collaboration
Microsoft Power BI
8.1

Report Output and Scheduling

Microsoft Power BI
7.9
Publish to Web
Microsoft Power BI
8.8
Publish to PDF
Microsoft Power BI
7.9
Report Versioning
Microsoft Power BI
7.7
Report Delivery Scheduling
Microsoft Power BI
7.7
Delivery to Remote Servers
Microsoft Power BI
7.3

Data Discovery and Visualization

Microsoft Power BI
8.1
Pre-built visualization formats (heatmaps, scatter plots etc.)
Microsoft Power BI
8.4
Location Analytics / Geographic Visualization
Microsoft Power BI
8.5
Predictive Analytics
Microsoft Power BI
7.5

Access Control and Security

Microsoft Power BI
7.9
Multi-User Support (named login)
Microsoft Power BI
8.2
Role-Based Security Model
Microsoft Power BI
7.3
Multiple Access Permission Levels (Create, Read, Delete)
Microsoft Power BI
7.8
Single Sign-On (SSO)
Microsoft Power BI
8.3

Mobile Capabilities

Microsoft Power BI
7.8
Responsive Design for Web Access
Microsoft Power BI
7.9
Dedicated iOS Application
Microsoft Power BI
7.8
Dedicated Android Application
Microsoft Power BI
7.8
Dashboard / Report / Visualization Interactivity on Mobile
Microsoft Power BI
7.8

Application Program Interfaces (APIs) / Embedding

Microsoft Power BI
7.1
REST API
Microsoft Power BI
7.6
Javascript API
Microsoft Power BI
7.4
iFrames
Microsoft Power BI
7.0
Java API
Microsoft Power BI
6.4
Themeable User Interface (UI)
Microsoft Power BI
7.4
Customizable Platform (Open Source)
Microsoft Power BI
6.9

Pros

  • 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.
No photo available

Cons

  • One of the major drawbacks of Power BI is its inability to do incremental data loads effectively. The data needs to be refreshed in its entirety, consuming a lot of resources., even when the same data is required in multiple tables. The query is fired for each instance of the table.
  • Lacks external input capabilities within the dashboard. There are no forms infrastructure to input and play around with the dashboard.
  • Time-based KPIs need improvement and needs modeling and constant debugging is required to get DAX based functions right.
  • The Q&A feature is far from being usable. The questions are often hard to put across.
  • The pivot functionality is highly under-utilized. The excel pivot tables can make Microsoft Power BIi a very powerful tool to use.
  • Hosting Microsoft Power BIi on portals akin to tableau online is not available
  • Minute details on formatting still needs to improve.
  • Data level security and user group specification needs to improve
  • On premise power bi report server are expensive option when compared to BI Tools
Rohit Acharya profile photo

Likelihood to Renew

Microsoft Power BI10.0
Based on 1 answer
I find it helpful and easy to use
jim paroly profile photo

Usability

Microsoft Power BI8.8
Based on 3 answers
PBI is very easy to use because of its similarity with power pivot and excel. DAX is the basic foundation language to be mastered to quickly build reports. Custom measures have been introduce to write instant DAX functions (But doesnt work all the time and need a understanding of DAX to debug). Easy to chart multiple charts and also third party charts
Rohit Acharya profile photo

Alternatives Considered

Based on the latest reviews from Magic Quadrant, Tableau is rated high among all the applications in this category with its rich features in terms of connectivity, visualizations, and various other features. But the cost of using the application is bit high from my personal experience. Also, Tableau does not provide free version for personal (Individual Users) use, unlike Microsoft Power BI. When you allow people to explore the software, there is a great scope that it penetrates into market with higher chances of making a positive decision to implement the Enterprise version (paid version for Businesses).
Sridhar Bojja profile photo

Collaboration and Sharing

Microsoft Power BI8.0
Based on 53 answers
Great application with features to use the application from any device (Mobile phones or computers or other GUI systems). User can set access roles while sharing the information, so that only those with permissible roles can view the data or insights relevant for them. Also, the information can be shared or published as web pages, so that the firm can release the public information on it's websites, instead of sending any newsletters.
Sridhar Bojja profile photo

Data Integration

Microsoft Power BI8.3
Based on 52 answers
Power Bi has wide range of data sources like Excel, Sql Server, Text, Csv, Web Server, etc. It also gives you the functionality of writing a blank query. All these data sources make it an interesting option. Although it's competitor's like Tableau provide few more data sources to import data. But if you have a small scale business and you have one of the data sources mentioned above, Power BI will be of great use
Kunal Sonalkar profile photo

Return on Investment

  • It's a good start for setting up customized dashboards.
  • Available for all users based on Office 365 platform we have in place.
  • Doesn't really allow depth of report - specifically customization of visual displays.
Mark Metz profile photo

Pricing Details

Microsoft Power BI

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details