What users are saying about

Microsoft Power BI

Top Rated
303 Ratings

Microsoft Power BI

Top Rated
303 Ratings
Score 8.2 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.

Feature Rating Comparison

BI Standard Reporting

Microsoft Power BI
8.2
Pixel Perfect reports
Microsoft Power BI
7.8
Customizable dashboards
Microsoft Power BI
8.7
Report Formatting Templates
Microsoft Power BI
8.0

Ad-hoc Reporting

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

Report Output and Scheduling

Microsoft Power BI
7.9
Publish to Web
Microsoft Power BI
9.0
Publish to PDF
Microsoft Power BI
7.9
Report Versioning
Microsoft Power BI
7.6
Report Delivery Scheduling
Microsoft Power BI
7.5
Delivery to Remote Servers
Microsoft Power BI
7.4

Data Discovery and Visualization

Microsoft Power BI
8.3
Pre-built visualization formats (heatmaps, scatter plots etc.)
Microsoft Power BI
8.6
Location Analytics / Geographic Visualization
Microsoft Power BI
8.7
Predictive Analytics
Microsoft Power BI
7.5

Access Control and Security

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

Mobile Capabilities

Microsoft Power BI
8.2
Responsive Design for Web Access
Microsoft Power BI
8.3
Dedicated iOS Application
Microsoft Power BI
8.1
Dedicated Android Application
Microsoft Power BI
8.1
Dashboard / Report / Visualization Interactivity on Mobile
Microsoft Power BI
8.3

Application Program Interfaces (APIs) / Embedding

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

Pros

  • Quick and easy dashboard deployment
  • Easy integration to existing system (both API and raw data imports were used)
  • Mobile platform (tablets) support

Cons

  • I love creating a matrix. It's very similar to the pivot in Excel. However, when I export out of power Bi into Excel, it turns back into a raw data dump. From there I can do the pivot in Excel, but what's the point of doing the matrix then. I would like for the data to export how the matrix is showing.
  • Small but important tasks like inserting a column, combining metrics like time and year, and many others take 3 or 4 steps instead of 1 to 2.
  • Googling "how to" when figuring out a sticky situation in Power BI doesn't always lead to a resolution. It's probably because not enough folks use Power BI like Excel, for instance, and thus you might only find one explanation to go by. And in some cases that ONE explanation isn't worded quite right for a particular user's level of expertise. With Excel, you Google a problem, and there are many write-ups to read through. And one of those write-ups turns the light bulb on in your head in your head. Or better yet you might read several different ways to solve a problem. Don't normally have that luxury with Power BI.

Likelihood to Renew

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

Usability

Microsoft Power BI8.7
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

Alternatives Considered

It is easy to store and retrieve data so that when there is a turnover we are able to find information that someone entered and then use that for the upcoming prospective reports. Also the visuals we are able to generate through the programming help us quickly build reports and share out to the community.

Collaboration and Sharing

Microsoft Power BI8.2
Based on 43 answers
Security and access control capabilities are robust enough, although there are some challenges with integrating with Kerberos; data sharing across the teams is seamless and robust if security is applied on the front-end as opposed to a pass-through entitlement resolved on the back-end; report distribution and formatting features are very solid.

Data Integration

Microsoft Power BI8.5
Based on 42 answers
Good range of data sources; what does have some room for improvement are the following modules: ease of merging data, wrangling, cleansing and conforming it to the standardized data model, applying data quality mechanisms based on artificial intelligence and machine learning algorithms, as well as sourcing data from/integrating data with real-time messaging infrastructure components.

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.

Pricing Details

Microsoft Power BI

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