Strengths and Weaknesses of Microsoft Power BI
Updated September 15, 2019

Strengths and Weaknesses of Microsoft Power BI

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft Power BI

1. It is used for Executive reviews for visualization and dashboards to provide insight in the business operations, marketing, finance. My organisation is using this because it comes free with Microsoft Office license. It provides similar services as other tools in the same field.
2. It is being used in my departmen,t but other functions are starting to explore this BI tool.
3. Visualization, dashboards, scorecards, easy to understand huge datasets through graphs and charts, flexible for users to connect withEexcel

  • 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
Scenarios where it is well suited- User with Excel experience and needs to analyze the data via visualization without spending huge money on license subscription of other software

Scenario where it is less suited - User who does not know how to handle big data and cleaning data requirements of BI.

Microsoft Power BI Feature Ratings

Pixel Perfect reports
6
Customizable dashboards
5
Report Formatting Templates
8
Drill-down analysis
5
Formatting capabilities
7
Integration with R or other statistical packages
Not Rated
Report sharing and collaboration
6
Publish to Web
10
Publish to PDF
10
Report Versioning
7
Report Delivery Scheduling
4
Delivery to Remote Servers
5
Pre-built visualization formats (heatmaps, scatter plots etc.)
10
Location Analytics / Geographic Visualization
10
Predictive Analytics
5
Multi-User Support (named login)
10
Role-Based Security Model
Not Rated
Multiple Access Permission Levels (Create, Read, Delete)
Not Rated
Single Sign-On (SSO)
Not Rated
Responsive Design for Web Access
Not Rated
Mobile Application
Not Rated
Dashboard / Report / Visualization Interactivity on Mobile
9
REST API
Not Rated
Javascript API
Not Rated
iFrames
Not Rated
Java API
Not Rated
Themeable User Interface (UI)
Not Rated
Customizable Platform (Open Source)
Not Rated