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.A Modular Approach to BIPower BI is currently being used by several management level stakeholders within our company. We have built a management data mart in Amazon Redshift data warehousing infrastructure which powers all the dashboards built on Power BI. Important company level decisions are made based on the Microsoft Power BI dashboards. There were numerous reports floating around in emails and Excel sheets with a different data definition for each report before Microsoft Power BI was put in place. The dashboards provide C levels to make critical decisions and the live data capabilities in Microsoft Power BI provides us to make marketing campaign decisions swiftly.,One of the most important features in Microsoft Power BI is its minimal learning curve required. excel proficiency would be enough to get even a non BI person to build powerful dashboards Powerpivot DAX functionalities are prevalent in Power BI which allows us to perform time series data manipulation. It also allows to Excel is versatile and Microsoft Power BI allows integration with office 365 and excel. Management often loves to view numbers on excel and with the help of plugins and publishing fixed pivot tables online, Microsoft Power Bi brings the functionality of excel to interactive dashboards. Multiple data source integration is quite powerful and robust. Microsoft Power BIis very modular if a functionality is missing a third-party app can be downloaded to fill the gap, this is particularly a powerful feature as not all tools can have all the features in place. Every month there are updates to the software and it allows for a free one year trial subscription The natural language query and machine learning support to analyze graphs and quickly summarize data is a fancy plus to have. The community is vast and open source communities are active to build apps and help to debug errors and aid in workarounds. The drilling functionalities on dimension allow the dashboards to be more interactive. The data can be manipulated step by step in the backend to arrange the data in the required format. Each step can be manipulated or isolated to achieve the desired result. Example Transform, Transpose, Reverse rows etc Dashboards are quite fast and interactive as the data is stored in the cloud in the backend instead of hitting the database It can connect to plenty of third-party online services to draw data like Google Analytics, Salesforce, and Sharepoint etc.,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,9,Tableau Server, Tableau Desktop, QlikView and Alteryx Analytics,8,7,Tableau Desktop, Birst,Ability to perform Data manipulation on the backend to arrange data as per dashboard and reporting needs Import various data sources from online services especially third party data serivces like salesforce, GA etc Comparing plan numbers and budgeting and also installing third party modular apps to support advance analytics,Input external data in a hosted dashboard Downloading sample data from the dashboard or easy sharing of a particular view or annotation Performing DAX based functions on time series and variance comparisons and making adjustment in viz.,Yes, but I don't use it,9Excellent Starting Point for BI ToolI used Microsoft Power BI to combine multiple sources of data into a comprehensive report. I had Salesforce, Excel sheets, and a few smaller tools that had information to combine into a single view. Being able to publish these reports publicly for shared access helped keep everyone on the same page.,It was very easy to use and learn. I did not have a lot of BI experience and was able to get started very quickly. Frequent updates continue to provide excellent new features. It has an excellent interface that makes the set up and layout of reports and dashboards very functional.,Some features are not available in both the desktop and web version, so I had to switch back and forth between the two in order to publish some of the more complex reports to my website. It did not have all the integrations that I needed at the time, so I was still using some Excel sheets to import the data.,9,Tableau Desktop,, Google Analytics, WordPress,, Jitterbit,6,8,Report creation Geographic Mapping / Heat Mapping Publishing to web,8A great way to visualize your dataPower BI is a very good tool to create quick reports with beautiful visualizations and a great tool to research your data visually. I think that seeing your data in a visual way can help you see things you may miss with a standard report. I use it to track my projects to compare costs and revenues.,Power BI allows you to show or look at your data in different types of visualizations easily and quickly. It is light-weight with great selection of visualization tools (with many add-ons available for extra types of visualization). You can create reports using the easy to use and elegant looking dashboard which would be familiar to Excel users. The data you analyze can come from single or multiple data sources, with a huge selection of data source types. The reports and graphs you create can be easily customized to suit your needs or taste. New features are being added rapidly (which can be a con for some as it can result in having to re-learn to use some of the operations).,May be a little hard at first for users with no Excel (or competing products) [experience]. Can be slow with large amounts of data. Office 365 version of Power BI is not as easy to use as the desktop version. Exporting and integration with other products can be improved.,10,I'm using the free version, so the only investment was the time spent to learn how to use the product (which as an Excel user, was very short). I use Excel to store every single bit of information about all the projects I do, and being able to see them visualized helped me see some redundant steps I was taking. No negative impact at all for me.,Excel,Adobe Photoshop, Adobe Acrobat DC, TextMagic, NetBeans, Google Analytics, AdWords, SAP Crystal Reports, WebSphere Application Server, SAP Business Objects, Drupal, Joomla!,1,1,Plan project budget based on previous projects Assess AdWord campaign success Compare expenses against income based on similar past projects,If and when my business will grow, I will be using the BI collaboration features to track all employee projects,10,Yes,Price Product Features Product Usability Third-party Reviews,I am happy with how and what I have selected. I could have read more reviews.,Selecting visualization type Connecting to data sources,Yes, but I don't use it,9
Microsoft Power BI
472 Ratings
Score 8.2 out of 101
<a href='' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>TRScore

Microsoft Power BI Reviews

<a href='' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Microsoft Power BI
472 Ratings
<a href='' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 101

Do you work for this company?

TrustRadius Top Rated for 2019
Show Filters 
Hide Filters 
Showing 3 of 475 Microsoft Power BI ratings and reviews.
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Job Type

Reviews (1-3 of 3)

Companies can't remove reviews or game the system. Here's why.
Rohit Acharya profile photo
February 23, 2018

A Modular Approach to BI

Score 9 out of 10
Vetted Review
Verified User
Review Source


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.
Read Rohit Acharya's full review

Feature Scorecard Summary

Pixel Perfect reports (60)
Customizable dashboards (72)
Report Formatting Templates (66)
Drill-down analysis (72)
Formatting capabilities (72)
Integration with R or other statistical packages (48)
Report sharing and collaboration (70)
Publish to Web (68)
Publish to PDF (60)
Report Versioning (51)
Report Delivery Scheduling (49)
Delivery to Remote Servers (30)
Pre-built visualization formats (heatmaps, scatter plots etc.) (67)
Location Analytics / Geographic Visualization (62)
Predictive Analytics (51)
Multi-User Support (named login) (60)
Role-Based Security Model (48)
Multiple Access Permission Levels (Create, Read, Delete) (54)
Single Sign-On (SSO) (36)
Responsive Design for Web Access (59)
Dedicated iOS Application (44)
Dedicated Android Application (47)
Dashboard / Report / Visualization Interactivity on Mobile (58)
Javascript API (24)
iFrames (24)
Java API (19)
Themeable User Interface (UI) (28)
Customizable Platform (Open Source) (19)

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