Microsoft Power BI Software

4.44 / 5 (359)

About Microsoft Power BI


Microsoft Power BI is a web-based business analytics and data visualization platform that is suitable for businesses of all sizes. It monitors important organizational data and also from all apps used by organizations. Microsoft Power BI provides tools to quickly analyze, transform and visualize data, and also share reports.

Microsoft Power BI offers SQL Server Analysis Services through which users can quickly build reusable models using the overall data. The software enables users to integrate their apps, so as to deliver reports along with real-time dashboards.

Microsoft Power BI also provides self-service access to major third-party cloud sources such as GitHub, Zendesk, Marketo and Salesforce.

Microsoft Power BI is available both in free and paid (Pro) versions. The free version is not limited by any time period; however data of only 1GB per user can be analyzed. Otherwise, it costs $10 per user per month for 10GB storage.



Read More

Supported Operating System(s):

Windows 7, Windows Vista, Windows XP, Mac OS, Web browser (OS agnostic), Windows 2000, Windows 8, Windows 10

359 Reviews of Microsoft Power BI

Average User Ratings

Overall

4.44 / 5 stars

Ease-of-use

4.0

Value for money

4.5

Customer support

4.0

Functionality

4.5

Ratings Snapshot

5 stars

(194)

4 stars

(134)

3 stars

(25)

2 stars

(6)

1 stars

(0)

Likelihood to Recommend

Not likely

Very likely

Filter reviews by:

Sort by: Most Helpful | Most Recent

Showing 1-20 of 359 reviews

Do you use this product?Write a review

September 2017

rajiv from Times Network

Company Size: 1,001-5,000 employees

Review Source


Ease-of-use

4 of 5

Value for money

5 of 5

Customer support

4 of 5

Functionality

4 of 5

September 2017

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

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.

April 2017

Jimmy from Distributed Solutions, Inc.

Company Size: 51-200 employees


Ease-of-use

4 of 5

Value for money

5 of 5

Customer support

3 of 5

Functionality

4 of 5

April 2017

Miscrosoft Power BI for Federal Acquisition Spend Analysis

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.

December 2018

Anonymous

Verified Reviewer

Company Size: 501-1,000 employees

Review Source: Capterra


Ease-of-use

5 of 5

Value for money

5 of 5

Customer support

5 of 5

Functionality

5 of 5

December 2018

BI tool with the coolest features

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.

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.

February 2018

Carlos from alcecal.com

Company Size: 2-10 employees

Review Source


Ease-of-use

5 of 5

Value for money

4 of 5

Customer support

3 of 5

Functionality

5 of 5

February 2018

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

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.

December 2018

Raghavendra from Aston University

Company Size: 1,001-5,000 employees

Review Source: Capterra


Ease-of-use

3 of 5

Functionality

5 of 5

December 2018

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

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.

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.

March 2018

Judith from Stoneleaf Construction, LLC

Company Size: 51-200 employees

Review Source


Ease-of-use

4 of 5

Value for money

4 of 5

Customer support

3 of 5

Functionality

3 of 5

March 2018

One tool for Business intelligence solution

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.

May 2017

Kenan from Maa Althahab Fragrances

Company Size: 201-500 employees


Ease-of-use

1 of 5

Value for money

5 of 5

Customer support

2 of 5

Functionality

5 of 5

May 2017

Microsoft Power BI, Master of the Analytics World

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.

February 2019

andrea from CVS Health

Company Size: 5,001-10,000 employees

Review Source: GetApp


Ease-of-use

4 of 5

Value for money

5 of 5

Customer support

4 of 5

Functionality

4 of 5

February 2019

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

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.

October 2018

Anonymous

Verified Reviewer

Company Size: 51-200 employees

Review Source: Capterra


Ease-of-use

3 of 5

Value for money

5 of 5

Customer support

3 of 5

Functionality

5 of 5

October 2018

Great Tool for Visual Analytics

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.

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

December 2018

stella from The Home Depot

Company Size: 1,001-5,000 employees

Review Source: Capterra


Ease-of-use

5 of 5

Value for money

5 of 5

Customer support

5 of 5

Functionality

5 of 5

December 2018

Easy and quick business analysis with Power Bi

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.

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.

November 2017

Ian from Rivalea (Australia) Pty Ltd

Company Size: 1,001-5,000 employees

Review Source


Ease-of-use

3 of 5

Value for money

5 of 5

Functionality

4 of 5

November 2017

Excellent learning curve experience within a familiar paltform

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.

May 2018

Denis from DBI

Company Size: 201-500 employees

Review Source


Ease-of-use

5 of 5

Value for money

5 of 5

Customer support

5 of 5

Functionality

5 of 5

May 2018

MS Power BI - take your business to the next level

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.

December 2018

Anonymous

Verified Reviewer

Company Size: 5,001-10,000 employees

Review Source: Capterra


Ease-of-use

5 of 5

Value for money

5 of 5

Customer support

5 of 5

Functionality

4 of 5

December 2018

MSBI - Fun to learn

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

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

June 2018

Gregorio from SIMNSA

Company Size: 2-10 employees

Review Source


Ease-of-use

4 of 5

Value for money

5 of 5

Functionality

4 of 5

June 2018

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

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.

December 2018

Anonymous

Verified Reviewer

Company Size: 51-200 employees

Review Source: Capterra


Ease-of-use

4 of 5

Value for money

5 of 5

Functionality

4 of 5

December 2018

Power BI as a BI Solution

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.

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.

October 2018

Anonymous

Verified Reviewer

Company Size: 51-200 employees

Review Source: Capterra


Ease-of-use

4 of 5

Value for money

5 of 5

Customer support

3 of 5

Functionality

4 of 5

October 2018

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

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.

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.

December 2018

Anonymous

Verified Reviewer

Company Size: 501-1,000 employees

Review Source: Capterra


Ease-of-use

4 of 5

Functionality

4 of 5

December 2018

Robust, with add-ons

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.

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.

March 2017

Anonymous

Verified Reviewer

Company Size: 201-500 employees

Review Source: GetApp


Ease-of-use

3 of 5

Value for money

1 of 5

Customer support

4 of 5

Functionality

2 of 5

March 2017

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

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

February 2019

Martin from Renewal by Andersen

Company Size: 501-1,000 employees

Review Source: Capterra


Ease-of-use

4 of 5

Value for money

5 of 5

Functionality

5 of 5

February 2019

Best analytic software I've seen

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.

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

March 2019

Gedson from Carrilho Engineering

Company Size: 11-50 employees

Review Source: Capterra


Ease-of-use

4 of 5

Value for money

5 of 5

Customer support

4 of 5

Functionality

5 of 5

March 2019

The analytics toolbox that fits all purposes

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

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.