Who Uses This Software?

Power BI is used by developers, analysts, IT, and other business users.


Average Ratings

390 Reviews

  • 4.5 / 5
    Overall

  • 4 / 5
    Ease of Use

  • 4 / 5
    Customer Service

Product Details

  • Starting Price
    $9.99/month/user
  • Pricing Details
    Power BI Pro
  • Free Version
    Yes
  • Deployment
    Cloud, SaaS, Web
    Installed - Windows
    Mobile - Android Native
  • Training
    Documentation
    Webinars
  • Support
    Online
    Business Hours

Vendor Details

  • Microsoft
  • www.microsoft.com
  • Founded 1975
  • United States

About Power BI

A suite of business intelligence and analytics with reporting, data prep, and data visualization tools.


Power BI Features

  • Ad hoc Analysis
  • Ad hoc Query
  • Ad Hoc Reports
  • Benchmarking
  • Budgeting & Forecasting
  • Dashboard
  • Data Analysis
  • Data Visualization
  • Key Performance Indicators
  • OLAP
  • Performance Metrics
  • Predictive Analytics
  • Profitability Analysis
  • Strategic Planning
  • Trend / Problem Indicators

Power BI Reviews Recently Reviewed!


Power BI is one of the most user friendly BI software for adding visual representation and analytics to your existing reports

Sep 22, 2017
5/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Comments: Overall good software for beginners and can be explored to get the best efficiency from the software

Pros: below are a few pros Sharing dashboard in a group a. Sharing can be done once you have the Pro version of Power BI. Dashboard can be shared with the respective department members or your own team members. b. Since you have prepared the dashboard you will be the owner and you can decide whether you want to give the other members only viewing rights or editing rights as well. c. With this feature reports will always be on the cloud server and can be viewed as and when required d. Reports can be downloaded as and when required. Viewing dashboard in Mobile/ tab and preparing phone layout a. Once a dashboard has been prepared and saved, the same can be accessed on Power BI App with the same login. b. Since the screen is small compared to laptop, all the dashboard elements can be redesigned to suit the phone screen. c. The other features remain the same and the dashboard is interactive on the phone as well however it cannot be edited on phone. Export dashboard to PowerPoint, PDF a. This is one of the most important features of Power BI. Reports or dashboards prepared can be exported on PowerPoint or PDF with a click of a button. b. Hence Management reports and department reports can be automated on Power BI and once you refresh the data, the report will be ready to share. c. One problem is that few images which are not compatible with PowerPoint don't show post downloading. Narratives for dashboard a. This is one of the recent features offered by Power BI. With the help of narratives you can get the insight of the dashboard in a story form. b. Narrative uses its intelligence to study the data and give output in pointers, paragraphs etc which can be customised. Importing visuals to suit your need a. Apart from the general visualizations available in Power BI, there are additional visualizations released by Power BI from time to time. These visualizations enhance the visual appearance as well as the adds to further analytics in different ways. b. Visualizations which have downloaded and used in the dashboard are Infographic designer, Narratives for Business Intelligence, KPI Column chart, and Timeline. Edit interactions in dashboard a. It is important to understand the interactions and groupings in power BI since with the help of these you can control which graphs you want to automatically change by clicking on the other. b. With the help of grouping you can define groups and sub group which can be viewed together as a group if required. KPI Column Chart a. This is a recent custom visual developed by Power BI. With the help of this visual you can put the KPI target against the actual on a monthly basis. b. Forecasted revenue/ cost can also be put in this visual which will be shown in different colour. c. Individual monthly targets can also be put which can be interchanged by putting variance. d. Data can also been viewed in a table form along with graphical.

Cons: One of the important features of exporting report in PowerPoint does not allow custom visual to be exported. Hence if there are custom visuals in your report then the same will show error once exported. Arranging dashboard is a bit tedious and takes a lot of time To share reports, we need to publish to MS Cloud. We cannot share report from Power BI Desktop For sharing a report even members to who report needs to be shared have to get Power BI Pro. Since the department to whom report is shared is just to view giving them a Pro license might not be useful.

Miscrosoft Power BI for Federal Acquisition Spend Analysis

Apr 24, 2017
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

3 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Comments: All in all, for the price, this is an excellent tool for helping your organization turn mounds of data into useful insights.

Pros: Power BI simplifies the process of combining different types of data sources to create a single data model. There are also many built-in Extract, Transform, and Load (ETL) functions that help reduce the time required to prepare data. Creating reports and dashboards is as easy as drag and drop. The Power BI User Groups are strong and plentiful, so you can always read through blogs to get answers to questions that you may have. The Power BI Desktop application is used to perform ETL, create reports and is free. The reports are published to the Power BI cloud service for sharing, which is also free with limited capabilities. For more capabilities, such as security groups and scheduled data refreshing, there is a subscription fee. Microsoft will be releasing an on-premise solution for sharing Power BI content via an update to SQL Server 2016 hopefully within the next few months.

Cons: It's not always easy to speak directly with a MS Power BI expert, so that is a bummer. Also, you have to sign up to the Power BI service using an email address in order to share and view Power BI reports and dashboards, but Microsoft doesn't yet support personal (.cox, .gmail, et.) or government (.gov, .mil, etc.) email addresses which is a real bummer.

BI tool with the coolest features

Dec 14, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: I love everything about PowerBI! I like to think of it as a revamped version of MS Excel but with features that exceed all expectations. PowerBI lets you create data models, use DAX to manipulate and summarise and finally display these summaries in fancy (yet easy to understand) visualisations. The best feature might however be the ability to share and collaborate on dashboards. PowerBI can take data from almost all possible sources - text, excel, SQL databases etc etc and integrate it all together to form dashboards that can be shared online in the form of webpages as well as workspaces.

Cons: There is absolutely nothing to dislike about PowerBI. The free version of PowerBI is a great learning tool and lets you accomplish almost all your reporting tasks while the paid version lets you automate all your reporting.

Overall: I have been using PowerBI from the past 3 years and have never looked back. It has helped me as an analyst to draw my clients into my stories. The automation aspect of PowerBI is hard to ignore. I have shared my dashboards and collaborated with teams which was a nightmare before. I love the addition of new features resulting from a dedicate community of PowerBI users (with very responsive Microsoft developers jumping in to solve issues). Mobile version of PowerBI is convenient and a hit with clients.

Power Bi its changing the way we interact with data, information and decision making

Feb 14, 2018
4/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

3 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Comments: Data is the new petroleum, Information is the new combustible; and Power BI will boost this challenging new world of information and analysis.

Pros: For the last 30 years I have been using Excel to work with Tables, Filters, Functions, Formulas, Conditional formatting, Graphs, Pivot tables, Segmentation and VBA to register data and analyze information. That was great. But now, with the huge amount of data, available from many sources and Excel limitations, we needed something more robust and Microsoft launched Power BI. I have been using it for more than a year. Now I don't use pivot tables and graphs for analysis anymore, I use Power BI visualizations to represent and summarize the data. With it's impressive tools including geolocalization, I have found more effective ways to convert, transform, represent, analyze and make better decisions and planning with Power BI. It's ecosystem composed of Power Bi Desktop, Power BI Services (in the cloud) and Power Bi apps, has allowed me to find very innovative and productive ways to monitor the performance of my business and improve communication with my clients

Cons: It is in continuous development. The first week of each month, Microsoft releases a new version of Power Bi, so we have to keep us updated to use the program efficiently. But the pros outweigh the cons.

Capterra loader

Power BI is a very powerful tool to graphically represent data for decision making

Dec 30, 2018
4/5
Overall

3 / 5
Ease of Use

5 / 5
Features & Functionality
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: The vast no.of data sources available means it has got all the bases covered. You can connect to SQL Server Database or an analysis service database which is vital for us. Apart from this, the ability to connect to excel and text files means we can make the legacy report more visual and fit it into our dashboard.The best of Power BI is the possibility of collaborating and sharing dashboards and dynamic reports so everyone is singing of the same hymn sheet. The large community of developers means there are constantly new visuals available which can used to awe the customers.

Cons: Power BI could involve steep learning curve for non-tech savvy people. It is difficult t convince managers to use Power BI over traditional pivot tables as it could be daunting to learn.

Unless you can play around with DAX queries, Power BI could be limited to the insights it can provide.

Overall: Overall, Power BI has been a game changer. The time saved on creating visual reports is immense and it makes up for some of the cons with software. They are constantly improving and adding new features which shows that they are listening to their customers.

One tool for Business intelligence solution

Mar 20, 2018
4/5
Overall

4 / 5
Ease of Use

3 / 5
Features & Functionality

3 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Comments: Power BI is awesome for companies which use Microsoft products on daily basis and for experienced excel users. if you got both things this is the low price answer to handle the data of the company.

Pros: To start it is important to tell that Power BI, as is part of Microsoft business suite, is linked to other tools as Excel and SQL Server. Therefore the integration of the data of the company in one place is very easy. Power BI has a very good capabilities for report visualization, having more than 10 different kinds of charts you are able to represent the data of the company in a huge variety of formats making analysis pretty fast and easy. Let me tell you the database connectivity capabilities are outstanding with excellent cloud based connections as well.

Cons: Using Power BI will be challenging if you are not a powerful Excel user. It has no way to clean up wrong data. The system assumes the data you are pulling in has good quality. Power BI sometimes is too complex to use because has many options to handle data and setting it for the first time becomes hard.

POWER BI : Excellent data analytics tool

Mar 26, 2019
5/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Microsoft Power BI is a helpful device. It is anything but difficult to utilize and get it. It has comparative highlights to Excel with the capacity to make and import diagrams and outlines and control them. The apparatus is mind blowing for making natural dashboards to bestow to various customers. The features and limits improve this much than a direct surpass desires file and make it easy to bestow to various customers. As it is a Microsoft item, it very well may be effectively coordinated with other Microsoft items, for example, Office 365, Excel and so forth.

Cons: There is dependably opportunity to get better. The UI is unpredictable and confounding in it. There are expansive portions in the instrument itself which is in some cases confounding to make sense of which part does what. To utilize Power BI effectively you need to utilize totally cleaned information, there is no extent of information cleaning in Power BI.

Overall: It is a useful asset with regards to Business use. You can do huge things with your information with Power BI. Dashboard creation, report age, information representation are some powerful models. I unequivocally prescribe others to utilize Power BI on the off chance that you are a specialist Excel client.

Power BI - A Datanuts Canvas

Apr 02, 2019
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: The best thing about Power BI is the ability to customize it to my needs. Meaning, I can make every report look and feel the way I want. If a visual is not available as a built-in service I can go to the marketplace and search for one. If the built-in calculations won't work for what I need I can code in custom calculations.

Cons: The interface still has the look and feel of Office 2010. For software that gets updated on a monthly basis, it is surprising to me that it still looks like a product from a decade ago.

Overall: Power BI allows us to deliver content and various reports to large groups of people at once. One of the best features that go along with this is the ability to use row level security so I can create one report, publish it for everyone, and yet they still only see the information they have permissions for. All in all Power BI makes creating reports easier and the end users get a better experience consuming the data.

Microsoft Power BI, Master of the Analytics World

May 08, 2017
5/5
Overall

1 / 5
Ease of Use

5 / 5
Features & Functionality

2 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Comments: Analytics world is the future, and Power BI is the master of all that Glob...!

Pros: As my experience as MIS Specialist in one of the most famous Fragrances Company in the Middle East, we see that in any company there's the accounting department that provide all reports and analytics that's demanded by other departments, according to that those guys have to do all there outcomes reports manually, and this process will cost time, efforts, stuffs,... for that one of great benefit from MS Power BI, is that he save me money, save me time, save me my the cost of wages for the accountants, my stuff in the accounting department is just about 5 great guys. All the mater is just I have to design the report and working on the Data Warehousing a little bit, then I can get my report in the target template that provide me all what I want, and furthermore, all reports up-to-date 7/24.

Cons: We still need the integration with other services, like Vend POS, Shopify directly without any intermediate programs.

Using Power BI for Data Visualisation

Mar 20, 2019
4/5
Overall

4 / 5
Ease of Use

3 / 5
Features & Functionality
Likelihood to Recommend: 6.0/10 Not
Likely
Extremely
Likely

Pros: It is able to take in multiple data sources and churn out reports in a visually pleasant form for ease of viewing. It greatly improves efficiency when we do not have to resort to using Excel to generate the exact data model we want. The ability to utilize SQL Server Analysis Services for our needs is very welcomed. I especially like the user-friendly interface that Power BI provides.

Cons: There are some segments and features of Power BI that requires a good amount of time to figure out. To utilize Power Bi effectively, the data has to be cleaned beforehand as Power Bi does not provide such tools.

Overall: We use Power BI to receive and visualize the wide array of data sources and provide us with a very detailed overview on monthly status. It is user-friendly and easy to pick up. Through Power BI, we were able to attain increased productivity and efficiency on some of our processes.

Power BI is the ideal tool to visualize and share your data

Feb 23, 2019
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Comments: In the company it has had a great receptivity due to its easy handling, it is the simplest BI tool to use since it is aimed at a general public, it has allowed us to publish reports and panels, collaborate as a team and share relevant information within and Outside the company. Thanks to its interaction with other applications created by Microsoft, we can access the information without problems at any time. Supervise the state of the company has never been so simple, through an active panel, so many partners and managers can be aware of everything

Pros: Power BI is a service or business analysis tool that is based on the cloud. It is a business analysis solution that allows you to visualize data and share information with the entire organization, providing a unique view of the most important data of your business. It can be used from the application or the website. It allows the connectivity with the origin of many data, which can be presented with panels and dynamic reports that manage to connect, model and explore the data with visual reports in which the entire work team can collaborate and which can also publish and share .

Cons: A negative aspect that can be mentioned is that some of the expert analysts of the company consider that the Power BI tool does not have enough scope especially when it comes to representing large volumes of data or in great depth since it is a tool aimed at people who They are not experts in data analysis, but business managers or executives in general. In addition, Power BI may require additional costs for the increase of data capacity.

Great Tool for Visual Analytics

Oct 22, 2018
5/5
Overall

3 / 5
Ease of Use

5 / 5
Features & Functionality

3 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Pros: It is a one-stop solution for visual analytics right from the Data Mash Up (Power Query) and Building Visualization. There is huge community (third party) who can build custom visualization to use in Power BI. It has greater flexibilty to address the complex business scenarios if you are well trained in DAX and M language. It can be integrated into many Microsoft Products like Share Point, O365 apps.

Cons: DAX is a tricky language used in Power BI by writing the formulas for creating the measures used in Visualization. This tool is designed by keeping in mind of Excel users but it very complicated to use if you doesnt know in and out of Power BI

Overall: I am using this tool since 2015. I struggled initially in writing the DAX Formulas to address different business problems. It is a great tool to use.

Capterra loader

Easy and quick business analysis with Power Bi

Dec 06, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: What I like most about this software is the possibility of collaborating and sharing dashboards and

dynamic reports. It is an excellent tool for conducting business analysis and making timely

decisions for companies. Another of its best features is that it has a large number of data source

connectors and its graphics are incredible, you can basically transform any amount of information

into graphics that are easier to understand and visibly more attractive.

Cons: Although I find it difficult to find a problem with this software, I can mention that the update cycle

is limited in the free version, so I recommend using some of its paid versions to enjoy better tools

and features because I think it's worth pain. I also noticed that there are differences between the

web version and the desktop version regarding the data preparation tools, although it is not

something that prevented me from enjoying the advantages offered by Power Bi.

Overall: I have been using this software for a few months, however the results I have obtained are

extraordinary and it has helped me to present the information to other members of the company

in which I work in a dynamic, attractive and easy to understand way, they can also use the Graphs

to develop different types of reports, summaries and analyze the data to make better decisions for

the organization, is excellent.

Excellent learning curve experience within a familiar paltform

Nov 09, 2017
4/5
Overall

3 / 5
Ease of Use

4 / 5
Features & Functionality

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Comments: Generally a good product that I am having my team self learn on and use in our management reports. Would like to see better connectivity to SQL within our secure corporate environment rather than having everything pushed to an Azure solution, which we are unlikely to get anytime soon. The pricing didn't seem to lend itself well to SME.

Pros: Power BI is free to learn on which is ideal for novice users and organisations that have limited experience with BI packages. The developmental nature of the package is also interesting as new features are added in response e to the user community feedback through the forums. The learning from community forums , on line tutorials and Youtube videos has been invaluable.

Cons: The limitations in the free version are frustrating as you can't share dashboards with colleagues unless they have Power BI. This means you can't show it off easily to others who may also start using it. Getting the IT department to implement this is a hard slog if you can't demonstrate the productivity gains to a wider audience. The CEO is not going to install Power BI, she just wants to see the output and then will endorse wider adoption.

MS Power BI - take your business to the next level

May 07, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Comments: If you want to understand in what direction to move your business, to be always up to date, to receive data from anywhere in the world and from any device MS Power BI definitely your choice.

Pros: You can access your data from anywhere in the world from any device and always keep abreast of your business. Great product from Microsoft. Easily connects to a large number of systems, can combine data from different sources. A large number of built-in reports and dashboards, informative charts that give a visual representation of your data. You can drill down into your data, publish your reports online, pleased with the opportunity to cost reports offline, followed by their publication. Deep integration with MS Office.

Cons: Really it is very difficult to distinguish what the cons on the background of a very large number of advantages. The only thing you will have to spend the time and effort is of course learning without which I think can not do everywhere, no matter what product started studying. The only sad thing is that to learn MS Power BI is possible only using your work account from Microsoft.

MSBI - Fun to learn

Dec 12, 2018
5/5
Overall

5 / 5
Ease of Use

4 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Microsoft Support and online self-learning information is one of things other Companies does not have and it is because MSBI is so populer

SSRS is best tool to design report , i find it time-saving comparing using Crystal

Report Subscription and email delivery, available various Report Types

As a whole package ,with SSAS and SSIS , its a great tool to accomplish any project

Cons: You need bit of developing experience to work on it like Data Source , Dataset knowledge

It works on Windows only

Configure and installation is difficult

Need more browser supported reporting features and mobile supported

Interface can be enhanced to Fill-good for users

Overall: I Just like this Tool , No Complaints , its the BEST

I love that you can get updated graphical reports from any device and in an agile, simple and parameterized way.

Jun 06, 2018
5/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Comments: In general what I like about Power BI is that it makes use of the tools that I already know as Excel and SQL Server, and it is integrated into the Microsoft enterprise suite.

Pros: For any executive it is always important to have the information in the moment when it is needed. Power BI helps you to achieve this and easily connects to the data repository, the system already includes a variety of informative graphics that help to present the information of a very visual way In addition the system allows you to delve into the data to see the detail of the origin.

Cons: This tool is so powerful that I can not think of any disadvantage in its use, but if I had to say something it is that you have to be very careful in the base of the information so that the reports that the system transmits are reliable, if the information has problems that is reflected in the reports that the system gives you.

Power BI as a BI Solution

Dec 18, 2018
5/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Four main things: 1. Ease of Use (same Microsoft intuitive feel) 2. Virtually connect to any data source and multiple data sources. Report on them individually or combined (great if you're looking to combine historical legacy data with new, current data from another source) 3. Scalable. Grow your business and Power BI grows with you. It can handle huge amounts of data 4.Bang for buck - so much packed into an affordable package

Cons: Ability to only refresh part of your data, not all of it, which can take a long time. Old data that doesn't change, for example, doesn't need to be refreshed every time along with the new data.

Although, I hear Microsoft is working on this.

Overall: With the use of existing free or premium connectors and templates, a user can get up and running with Power BI in minutes and have access to hundreds of prebuilt visuals and analysis instantly - with their own data.

Power BI might be the best way to start a BI practice

Oct 05, 2018
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

3 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: I was able to create out daily operation KPI dashboards using Power BI in a very few days only using a very cheap Udemy course as training.

For internal usage it can be a very affordable solution when compared to mostly every other enterprise BI solution in the market.

Some of Office 365 services are already integrated to provide datasources to Power BI in a very simple way.

Cons: Microsoft's documentation for Power BI wasn't useful at all.

It works in a completely opposite way to how Excel woks, I expected that my experience using Excel would be helpful, but it wasn't at all.

It lacks a lot of features for data processing and transformation that are expected on any BI solution, like the ability to to column vs rows transposition.

There's no integration between Power BI desktop and web.

Overall: As a starting point for our BI practice it worked just fine. Now, after 2 years we are beginning to have issues due to not available features. So far we are able to implement workarounds in the source databases before Power BI consumes data. We know eventually this has to change.

Robust, with add-ons

Dec 13, 2018
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Pros: The basic features are easy and accessible. You are able to perform quick reporting with a reliable dataset that is accessible from web and desktop platforms.

Cons: Some basic features which would be useful are missing. In a lot of occasions you can do some of the same things you'd do with a pivot table, but it's much more arduous and either requires unreliable community add ons or for you to learn how to program equations and new data sets that aren't immediately obvious.

Overall: PowerBI is great for what it is. While there are more out of the box robust options on the market, PowerBI has its place. It allows us quick access to copious amounts of data that the CRM complicates getting reports on and allows us to visualize the data more succinctly than a typical Excel readout. It is not without its faults, as some things remain easier and quicker within Excel, but it works wonders for quick read outs and visuals.

A pretty reporting tool for some (!) Microsoft Products, but pretty much useless outside of the Microsoft Landscape

Mar 18, 2017
2/5
Overall

3 / 5
Ease of Use

2 / 5
Features & Functionality

4 / 5
Customer Support

1 / 5
Value for Money
Likelihood to Recommend: 2.0/10 Not
Likely
Extremely
Likely

Comments: In light of the hype around this "Tableau destroyer" in recent months, I want to highlight some fundamental flaws in data connectivity and reports maintenance of Power BI, which the Product Team so far has turned down as "not in scope". In practice, though, this renders Power BI pretty useless for getting dara from any 3rd party products, in the cloud in particular. This review reflects Power BI as of mid March 2017. I have gathered my knowledge from testing, community interaction and a dozen tickets with Power BI Pro Support. The focus lies on getting data via Web Services, much aligned with Microsoft's «Cloud First» Strategy. 1) Power BI Online is in the cloud, but does not allow for HTTP calls. Power BI Desktop allows for HTTP calls, but only with static authentication parameters. First of all, a distinction needs to be made between Power BI Online and Power BI Desktop. While Power BI Online is the "master" that ultimately allows you to share and publish your reports, user experience in design is diminished by HTML limitations (you may know from Word or Excel Online) and more importantly, data connectivity (Get Data) is limited to SQL Servers on Azure and about 20 to 30 plugins from 3rd party solutions at present. Take note that on Power BI Online, you cannot select or manage your Gateways, either. This brings the attention to the Power BI Desktop client. Updated every one to two months, the Desktop client brings data connectors necessary to connect to a larger number of data sources. With the Web connector, HTTP calls been configured, although with just static headers and parameters and Basic and Windows authentication only. Importantly, though, Power BI Desktop includes Microsoft Power Query, which you may know from Excel 2016 already. With M Scripts, you can script and customise in many ways and most interestingly, convert it into table form quickly. This is where Power Query shines. However, Power Query does not seem to call on methods for nonces and timestamps required in token based authentication (OAuth for example). (Should this be incorrect, please please let me know. I have been browsing the fora and nagging Support too long already.) What's really amusing here is that Microsoft Azure uses OAuth 2.0 themselves. So, you cannot run any reporting on Microsoft's Azure AD or Resource Manager database for example, a notorious blackbox. Back to Powershell. (Power BI does not accept Powershell feeds.) In short, while Power BI Online does not allow to get any data out of the web (except for those 20 to 30 plugins, mostly Microsoft Products), Power BI Desktop allows for Web calls, but only with static parameters and thus, basically with your user credentials. That's a big limitation in Data Connectivity. 2) With Power BI Online being the master, the HTTP calls cannot be scheduled or refreshed in the cloud. Now that you have configured your HTTP call (with risky user credentials), you want to publish your report and have it refreshed on a scheduled basis, say every day. Tough luck. While you can publish your Report to Power BI Online and subsequently a broader audience, it's a static image of your Desktop data. You cannot schedule a data refresh in Power BI Online (because there is no Web feature anyway) and you cannot even refresh the data manually as this requires republishing the Report anew. You risk your management looking at outdated data whenever you forgot to republish your report and sneak the new URL into your dashboards and iframes. 3) The On-Premises Data Gateway is pretty useless for Web Services. Yes, there is the On-Premises Data Gateway. Yes, you can configure Web Services in the gateway, although it's pretty ironic to route web calls via on-premises infrastructure. But did you ever try it? That is, you cannot specify any HTTP headers fort he calls at all, lest writing a Power Query script. And thus, we are back at authentication via Basic and Windows only and writing REST scripts in the data source for every single HTTP call because with no Headers and Body, all parameters need to be coded in the URI. Will you do that? At the end of the day, Power BI is Microsoft's long overdue acknowledgement that Excel and some Dynamics Reports do not cut it for Reporting purposes. Indeed, for reporting on SQL Server, Dynamics 365 (if you want to afford it), and Excel and Access databases stored in your OneDrive, Microsoft Power BI does a neat job. However, as soon as you want to integrate with 3rd party systems or via web services in particular, Power BI presents so many limitations in authentication, Header and Body configuration, scripting, and scheduling that you need to configure an entire SQL Server environment (on Azure or On-Premises via feature poor Gateway) and write a SQL CRL interface or buy Azure Data Factory to get that data in. For some pretty reports, do you really want to buy and customise all that BI infrastructure on Azure? My advice to Microsoft: Work on Data Connectivity, especially in Power BI Online, rather than more visuals for those limited data sources. Your Microsoft clients will consider Power BI a given for the utter lack of reporting in Office 365, Azure, or Dynamics 365 (yes, pushing it there). My advice to Users: If the connectors are not listed, look somewhere else. (And make sure it's your use case that is listed. Power BI announced an Azure AD connector, but rather than reporting on Users, Groups, or Enterprise Apps, you can only see on a nice map where the last logins happened.) Is it a Tableau destroyer? No. It's a long overdue acknowledgement for necessary reporting with the potential of being a solid Business Intelligence solution ONCE focus comes to lie more on data.

Pros: pretty visuals Power Query On-premises Data Gateway responsible Pro Support

Cons: lack of data sources pretty useless for 3rd Party Web Sources

Recommendations to other buyers: My advice to Microsoft: Work on Data Connectivity, especially in Power BI Online, rather than more visuals for those limited data sources. Your Microsoft clients will consider Power BI a given for the utter lack of reporting in Office 365, Azure, or Dynamics 365 (yes, pushing it there). My advice to Users: If the connectors are not listed, look somewhere else. (And make sure it's your use case that is listed. Power BI announced an Azure AD connector, but rather than reporting on Users, Groups, or Enterprise Apps, you can only see on a nice map where the last logins happened.)

Data Visualisation with user friendly interface

Mar 28, 2019
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: It not only has desktop based versions but has native apps for iOS, Android and Windows as well. A major plus point where our team is able to make use of Power BI on the go. As part of Microsoft suite of applications, it is able to easily extract data from a multitude of sources and very easily package them into a visually pleasant data report.

Cons: It does not have the ability to clean the data from the list of data sources we input. This has to be done outside of Power BI before it can be fed into the application for data visualization. A rather steep learning curve for people without the technical knowledge in the first place.

Overall: We make full use of the business analytics and data visualization tool within Power BI to spot trends within our database and to present to the management on findings through the reports.

Capterra loader

Best analytic software I've seen

Feb 09, 2019
5/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Once you understand how Power BI works, it is incredibly easy to use and adjust charts within a worksheet. It's amazing how fast you can filter data and how the graphs are synced/auto update. Slicing data in ways that would take hours to do in a tool like excel can be done in minutes using BI, it's incredible. I used to use Microsoft excel daily to analyze data, and now I almost never use it because the data can be imported and quickly analyzed using BI. It also handles large data sets better than excel and other similar software I've seen. This is by far the best analytic software I've seen, and think it is very underutilized.

Cons: There are a few quirks with the software that make it a little bit difficult to use. While the table of errors when uploading software is nice, it would be nice if the table updated each time you loaded additional. data instead of creating brand new table. Also when uploading information from excel, it would be nice if the software could handle "#NA" cells from invalid excel formulas

Overall: This software has been one of the best things I've found to use and analyze data, and has made my job so much easier.

The analytics toolbox that fits all purposes

Mar 12, 2019
4/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Power BI is very flexible and adaptable, it comes with lots of data source integrations and can handle many different formats. It's featured with a very powerful analytics set, that's both easy to get started with and can provide very complex analysis for the advanced users. The user interface is very well designed too, everything is in the right place and immediately accessible when needed.

Cons: The advanced analysis are not easy to understand, there's definitely room for improvement in guiding users here.

Overall: We hardly use spreadsheets anymore for any kind of analysis, as Power BI provides such an added value over them.

Enjoying the visuals and the intelligent reports that PowerBI makes!

Jul 24, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: I love that they have a free version for developers, and it is very cheap for non-profits. It has a lot of flexibility when it comes to connecting with several interfaces. It has a lot of the recipe features that Google Data Studio has. If you are already a user of several Office 365 products, you'll enjoy this a lot, because you don't need to create a lot of mappings. I like the interfaces that it has with Mail Chimp and Google analytics (and several others), as it comes with recommended reports which you could take live from the sources. It didn't take me a while to get used to using PowerBI. If you have some Business Intelligence knowledge, this will be a piece of cake for you.

Cons: If you use a for-profit pricing, you might not like the pricing that they have for PowerBI. It's still relatively cheaper compared to other tools, but you might reconsider other products just because of the pricing.

I used this business tool in my work as an Process Intelligence Analyst at Univera.

Jul 12, 2018
4/5
Overall

3 / 5
Ease of Use

4 / 5
Features & Functionality

5 / 5
Customer Support

3 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Pros: It's features are extremely robust and has some of the best integration for data warehousing of any "off the shelf" tools. I think Power BI is great for medium scale companies and ventures because there's a ton of support from Microsoft and third party companies as well. Most large organizations, in my experience, should have enough staff with Power BI knowledge to call on as business experts.

Cons: I think some aspects are a bit counter-intuitive to use. Power BI's does help to make users more comfortable with it though. I also think that the heavy reliance on cloud services makes it a bit harder to integrate some legacy systems that aren't well configured into the BI environment.

Overall: I was able to integrate it into a fairly outdated Microsoft office suite, so that was really useful for me. My organization uses a lot of legacy software for security purposes, so it was nice to have a Business intelligence tool that can be easily deployed "out of the box", as opposed to some newer tools. I was fairly easily able to generate reports, pair it with an ETL tool that I was using, and pretty much speed up a few reporting processes.

Perfect For Insight Generation With Google Ads Linking

Dec 20, 2018
5/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Easy to generate user friendly visualizations that would otherwise be a nightmare to describe.

Excellent Third Party Linking

Great Online Community for finding support and other great ways of using the tool.

Cons: Uses connectors that could be hit or miss. In my case took me several times to connect Google Analytics to Power Bi due to connector not working as should.

Overall: The online community of users is definitely a place you will appreciate in the beginning as you get to know the intricacies of the software and its true power. Regardless of the initial hiccups to connect Google Analytics with the software, I definitely appreciated the utilization of visuals to represent data that other words could have been very boring and dull for board members to understand.

Power BI for Digitalizaton of Order Flow

Mar 26, 2019
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Comments: By using DAX in Power BI, ERP/database connections, implemenation of the latest algorithms for managing bottlenecks , Buffers, and the DDMRP principles, we are developing a robust platform for different users for managing the order flow in organizations

Pros: It enables the use of BI, the connection of various databases, calculations that are difficult to make in the classic ERP / MRP, especially for the field of planning and monitoring the execution of orders in production.

Cons: Refreshing data in PBI Pro is limited to 8x per day, which is insufficient.

Constantly Improving

Nov 27, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: While already a robust and competitive analytics software, Power BI is constantly coming out with new and improved features and functionality. The integrations with Excel is impressive and makes my life so much easier.

Cons: There still isn't a good integration with Microsoft's other Office programs other than Excel. Integration with Word, PowerPoint, and Outlook simply doesn't exist yet, and it should.

Overall: Power BI has transformed how our company looks at data and reporting. It just keeps getting better and better.

User Friendly tool

May 15, 2018
4/5
Overall

5 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: - amazing tool for excel gurus, the interface is just like excel - very user friendly - great visuals and interactive reports - power bi.com service is useful feature for publishing reports - phone apps are helpful at times - great features like data modelling , group by, merge, combine for large data sets - open source desktop version

Cons: - 3rd party visuals cannot be exported to power point - can get slow when refreshed (like updating more data to the visuals) in desktop version

Power BI continues to add new features and functionality

Aug 15, 2018
4/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Power BI is easy to use. The learning curve is low. However, it still provide rich features and functionalities . It is a great visual tool.

Microsoft continues to provide monthly updates on adding new functions.

Cons: The ecosystem of Power BI is confusing for the beginner. There are Power BI cloud version, On premise version, on premise data gateway. There are two versions of Power BI desktop.

The workspace in Power BI currently does not provide enough tool for users to easily share the content for non-Pro license users. There isn't a easy way to share to everyone within large organization other than Power Apps.

Ease of use of Excel with elite level visualizations and storytelling

Jul 31, 2018
5/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: The most powerful uses of Power BI are how easy it is to use. It connects to almost every data type imaginable and has countless intuitive visualizations built in. Their open-source visualization library is great for finding new visualizations on the fly. Excel users feel right at home with making graphs, tables within the tool and can create a solution that can be automated and deployed.

Cons: DAX is the formula language used to create functions and calculated fields within Power BI and it is difficult to use at times. Additionally Formatting a Power BI Dashboard for the best appearance can be difficult as solutions normally look very spacy or extremely cluttered.

Overall: Excel to the highest level. I get to create dashboards and solutions to embed within websites that users have access to that automates easily and can handle huge datasets

Great system and makes for a very productive day.

Jul 23, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: It seems very versatile. I have been using it daily for the past year since it was implemented here at my work. It allows for ease of day to day managing of files and allows for me to maximize my productivity. We have it customized to individual department use so this allows for my team to up their productivity. Easy system to learn and overall very user friendly. It can also be integrated to be used with other systems.

Cons: Honestly, I have not found anything that I dislike about this software to date. No glitches or bugs .

Overall: Allows for a great work environment and to maximize overall productivity.

Business Interlligence on Steriods....

Mar 19, 2019
5/5
Overall

3 / 5
Ease of Use

4 / 5
Features & Functionality
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: I especially liked the customisation of the interface, we were able to create easy to use dashboards within minutes that we could share with the client

Cons: Not very exportable friendly, had to take screen shots as the pdf versions looks poor.

Overall: We needed to implement a shared visualtion of a clients new cases open, closed and the revenue attributed to these.

With this data we were able to overlay this with our marketing activities, to provide a true ROI on media spend to bookings.

Excellent product for data visulization from small business up to enterprise level

Jul 10, 2018
4/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: The amount of different types of data that can be integrated and analyzed makes this an extremely powerful tool. Businesses from small to large can integrate essentially any data stored digitally for cross reference, analysis, and visualization. Our organization has realized new avenues of business analytics with the options available in Power BI. Dashboards have allowed a more free flow of processed information and has reduced the need for some in-person exchange of the same information (meetings, status calls, etc.). C-suite engagement with Power BI dashboards have provided new strategic opportunities by allowing executives to focus more and spend less time

Cons: Power BI has a decided learning curve and can be daunting for new users. There are, in many cases, lots of ways to do the same thing and learning the most efficient use of the interface and the tools at your disposal can take some time.

Analyze and Act

Mar 05, 2019
5/5
Overall

3 / 5
Ease of Use

4 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: I love that we can gather all of our data and then see meaningful graphs to analyze our next steps. We use this both internally and client facing to show our clients all the pertinent information they would need.

Cons: It does take a good amount of experience to learn how to effectively use it. More information on how to use KPIs would be nice.

Overall: I love this software and it has provided our clients with great analysis of key metrics.

This is not SSRS or Excel

Nov 07, 2018
4/5
Overall

4 / 5
Ease of Use

3 / 5
Features & Functionality
Likelihood to Recommend: 6.0/10 Not
Likely
Extremely
Likely

Pros: Ability to pull in data from tons of sources including on premises SQL. It's easy for new users to drag and drop stuff and the language isn't super complex. The service also now hosts RDL files for a one stop shop for reporting. Flexible security options.

Cons: It's so limited in functionality that you often find your self asking "why can every other MS product do this EXCEPT power bi?" The desktop client loves to crash on underequipped machines instead of throttling itself. There isn't a good way to partition workspaces into dev and prod, for example.

Power BI on the way forward

Oct 25, 2017
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Comments: I am now on my third BI Project in which I created the User interface with Power BI Reports and Dashboards. So far the clients were extremely happy with the way Power BI looks as well as how easy it is to learn. The most popular feature is the report interactivity - clicking in a chart is filtering the rest of the report accordingly which is really fun to make use of.

Pros: - Easy to use - Easy to learn - very intuitive - Allows powerful calculations - constantly new features and developments - great community, you can find an answer to almost any question - very interactive, it tempts to play around with the reports

Cons: - Some small bugs here and there, due to the ongoing development - At the moment On-premises version does not offer the same scope as the Cloud version. Cloud is more comprehensive.

Number Crunching at it's best

Jun 09, 2017
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: The ease of use of the software is particularly appealing as it is built on the usual Microsoft office interface. I particularly also like the fact the software is available in Desktop and online versions and there is synchronicity between the desktop and cloud versions. Conclusively, diversity of data sources allows for versatility.

Cons: People without private emails cannot publish and this frankly doesn't allow for easy training of other persons Downloaded visualizations files cannot be imported in multiples and this reduces efficiency a little bit.

Future is here!

Oct 18, 2018
5/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: This suite is quite impressive. It combines the very best of reporting software/dashboard solutions into one very powerful suite. You can make charts, interactive workflows, and do all your reporting in one powerful program. The UI looks like any other suite, but the pivot-table-looking options which allow you to slice/filter the data is such a nice change of pace. You can quickly add/remove any feature/filter you want without having to make any code modifications. This is a very handy tool if you need to provide weekly/monthly reports for any reason, simply update the data and refresh the report and that's it! And don't forget that this program is just going tog et better and better as time goes on!

Cons: The only drawback to his fantastic suite is that it takes a bit to get the hang of using it. There are so many features and things you can do it can be a bit overwhelming. Otherwise, the only drawback is that it wasn't out sooner!

Overall: 99/100. Very impressed with this program and am going to be using it more as it fits all my needs.

Excellent tool to manipulate complex forms of data

Nov 22, 2018
5/5
Overall

3 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Comments: Great tool for any business that is looking for custom complex data analytics.

Pros: This powerful software gives you the power to access data in the most detailed manner. This application is endless and could save your company thousands of dollars on data analytics.

Cons: Difficult to use and requires a steep learning curve in order to access the amount of data this application has to offer.

An amazing tool for analyzing data, a bit too complex, a bit too much

Sep 20, 2018
5/5
Overall

2 / 5
Ease of Use

5 / 5
Features & Functionality

1 / 5
Customer Support
Likelihood to Recommend: 3.0/10 Not
Likely
Extremely
Likely

Pros: It has all the power you may expect from a BI tool and a Microsoft product, the ability to create and analyze data cubes is second to none. User interface is sort of familiar as it follows the Microsoft way. Author version is free so you can play with it.

Cons: It's a complex tool to use and will rapidly go beyond your regular Excel-user. I would recommend to exhaust options in Excel (a tool that most of your staff would know by now) and even to step into Power Pivots or so (which is just an add-on to Excel but will allow you to mine huge data sources). By the way, remember that you will need someone knowledgeable on Data handling within your organization.

Capterra loader

Free Business Intelligence?

Dec 16, 2018
5/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Depending on your needs, it may be the free version is all you need. Visualizing your data is remarkably easy--Microsoft has connections already built for many common services, so you just provide your credentials, choose which elements you want to visualize, and then publish it. It's incredibly easy to add interactive charts, graphs, maps, etc, to your website, all updated in real time if your data source supports it, or you can use a simple spreadsheet as your data source if your data supports it. It's nearly the equal of long-time market leader Tableau, but much less expensive. And it nicely integrates into your Office 365 portfolio if you use that.

Cons: If you want to collaborate on shared data and distribute with apps, you have to purchase a license. Also, Microsoft is adding features as such a fast rate that finding documentation on how to use them is sometimes challenging.

Overall: We use Power BI to publish visualizations of Google Analytics on our websites. We also use it to show reports tracking how our employees are progressing towards accomplishing their goals. Finally, we use it to depict geographically where our grant money is being allocated (Power BI integrates ArcGIS). The latest GIS updates are some of Power BI's niftiest features!

Very easy to adopt BI or Visualization Tool

Jan 09, 2018
4/5
Overall

5 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Comments: If you have no enough budget to begin your visualization and data analyze cases and you also don't like other commercial or open source BI or visualization tool, you should try it first. I believe you will like it. BTW, I still think Tabelau is best one tool of visualization and its cost is also expensive.

Pros: Easy to use, get Desktop designer tool and cloud-based server. You also can choice on-premised Power BI server for your local deployment needs.

Cons: Because Power BI Report Server(On-Premises) must use SQL Server Report Services and SQL DB, you must understand how to manage SQL SSRS. At right now, this license model is strange for understanding. I think Power BI Services's license model(Cloud based) is very easy to understand.

Unbelievable software! Like Crystal reports on steroids!

Feb 06, 2018
5/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Comments: Overall an amazing tool that is so powerful. Once you get up to speed on how to navigate and use it you will become hooked on it. The drill down function is awesome. like Crystal reports on steroids!

Pros: This is such a powerful data visualization tool. IT is so flexible and easy to use. We use it to pull data from multiple databases. It gives us such a great visualization tool to show trends.

Cons: It is so flexible at times it can be hard to narrow down how to show a particular data set. It is not as intuitive as it could be navigate.

Affordable and Powerful, but the learning curve might be too steep for non-savvy users

Mar 21, 2019
4/5
Overall

3 / 5
Ease of Use

4 / 5
Features & Functionality

5 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 6.0/10 Not
Likely
Extremely
Likely

Pros: - Strong integration capabilities: Has an extensive library of connectors for most types of on premise and cloud based platforms. There is even support for obsolete platforms such as FoxPro using standard OLEDB drivers.

- Powerful tools for reporting and visualization

- Ease of use for power users - If you're savvy in Excel or Access you should catch on very easily

- Pricing: The desktop version is free, while the cloud version is only $10/mo. The pricing is competitive to Tableau software.

Cons: - The software is intended for power users. Non-savvy users in our organization had a difficult time navigating through the platform.

- Performance can slow down when connecting multiple larger data sources

Overall: Power BI became our platform of choice for reporting and dashboards within the company. We liked the powerful capabilities and pricing when compared to Tableau. However, we did not foresee the steep learning curve for non-power users, and had to invest additional resources into training end user staff to use the software effectively.

Building dashboards and predictive models to reduce hospital remissions

Oct 12, 2017
4/5
Overall

3 / 5
Ease of Use

5 / 5
Features & Functionality

3 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Comments: This tool, like so many other Microsoft developments, is a game changer in the analytics and reporting world. Power pivot is now native to Excel, and can basically turn a mid-level spreadsheet user into an analyst and DBA through DAX, M Query, and the ssas architecture that underlies it's capabilities. The addition of power BI increases that ability even more by integrating more data sources, providing a more user friendly interface (including NLP!!!), and dashboards that look as good as any other (one of excels major drawbacks), I'll be interested to see if the competition has a good answer.

Pros: I love the number of files it recognizes and the ability to integrate then into a single data model. Also, very convenient tool that offers a one stop service for database administrative, data analytics, and user friendly reporting.

Cons: No scheduled updating for olap or odbc linked reports. Despite operating on a Microsoft infrastructure that has the capability, this is a glaring imperfection.

VERY FUNCTIONAL

Sep 10, 2018
5/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Power BI is well suited for creating reports, specially when dealing with high volumes of data. The possibility of creating dynamic reports, with variables working as filters, is also a great tool for those who seek to produce a presentation: in some scenarios, PowerBI can even replace keynotes or powerpoints, as it allows to to present in a dynamic way all the information you have been analysing.

Cons: One of the main limitations of the BI Power is that it does not have the capacity to publish reports with all the associated data. This means that some data may be left out of visualizations.

Capterra loader

Intuitive and Powerful Data Crunching

Nov 20, 2018
4/5
Overall

3 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Power BI is fairly easy to configure and with built-in data source connectivity, allows us to analyze just about any data from any source. Limitless possibilities for presenting data in an easy to analyze format.

Cons: Two separate versions are required for full featured functionality - desktop and webservice. This makes it tough to remember which one is needed for different extracts and functions. Could make them more similar.

Need to break myself from wanting to set up everything like a pivot table!

So many features forces a larger than normal learning curve to fully get to know all options. Would be nice to have a customize feature that loads or displays only the functions and charts we are likely to use.

Overall: I've been working with Power BI for only a few weeks, but have found it very handy for XML cloud downloads (our BOMs that are in three separate tables from the host), much of our standard reporting (replacing large and clunky VBA scripted workbooks), and super fast and intuitive charts from our iSeries ERP and Oracle shipping databases.

So much connectivity to just about anything one could need or imagine when constructing a beautiful dashboard!

It's been fun playing around with the different charts and assemblies and trying to guess how my customers will utilize the data. I am sure interest from the users will increase immensely over the next several months, once they see how other departments are using their new dashboards.

Excellent Visualization Tool

Aug 16, 2018
5/5
Overall

5 / 5
Ease of Use

4 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: This is the best visualization tool on the market as well as the cheapest. Very easy to use as it is based on excel.

Cons: Lacks some of the features and tools as some of the other products that have been in the market longer.

Overall: Use to create dashboards for visualization of data and content sharing.