
Microsoft Power BI
Overall rating
Filter by
Company size
Time used
1579 Reviews

- Industry: Computer Software
- Company size: 501–1,000 Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
How Powerful is Power BI ?
Reviewed on 03/06/2021
I am a Power BI Developer and have delivered many dashboards to the client in Power BI. Its Better...
I am a Power BI Developer and have delivered many dashboards to the client in Power BI. Its Better than other Products. Its Save my lot of time by using Power BI various features. From Importing the Data to Publishing ,Its a easier platform I would suggest you to use. It contains the most trending Visuals in the market that a every developer wants.
Pros
1)Its Easy to use, Provides a Reliable user interface .
2)Its Time efficient as most of the work Power BI does it even before you know.
3)Integration to the third party visuals and creating its own market place have already took it way further than other products.
4)A User can customize its design and can easily give the dashboard access to the public.
5)It contains the most trending Visuals in the market.
Cons
1)Software is reliable on Latest Machines.
2)Old machines then need to be upgraded(OS, RAM) to use this software smoothly.
3) Multiple Dashboards can hang the entire system.
Alternatives Considered
TableauReasons for Switching to Microsoft Power BI
Its Integration among other Microsoft Products . Easier to Clean the Data and create beautiful Visuals in matter of time. Gets Published and can also export to website without throwing any error. Its a great Platform!
- Industry: Banking
- Company size: 2–10 Employees
- Used Daily for 6-12 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
Great tool for Data Analysis and Dashboards
Reviewed on 11/11/2022
My overall experience is great, using it to compile, perform ETL, prepare reports and create...
My overall experience is great, using it to compile, perform ETL, prepare reports and create Dashboards is simply powerful.
Pros
This is a great tool that integrates perfectly with Microsoft Excel (they are from the same family) it really makes life easy. Another great feature is the possibility to connect with a wide variety of sources such as Google Analytics, Facebook, SQL, data files, cloud files, and the list goes on. Free to use and very affordable price. Finally their visualization features are also impressive.
Cons
Like any other tool, we found a high amount of the time required to train and master it, when you try to go beyond create reports, you would need to learn about additional tools like Gateways and Report Server. In addition, their language DAX is not the easiest language to work with, but nothing some training and research can't solve.
Alternatives Considered
Qlik Sense, Tableau, SAP BusinessObjects Business Intelligence and IBM Cognos AnalyticsReasons for Choosing Microsoft Power BI
Power BI presented better tools to perform Data Analysis and work with Data.Reasons for Switching to Microsoft Power BI
When performing our cost / benefit analysis it came with the highest rate.- Industry: Computer Software
- Company size: 201–500 Employees
- Used Weekly for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
Microsoft Power B1 is a Useful Tool in this data driven Digital World of Today
Reviewed on 11/10/2023
Overall, this is a great product for data visualization.
Overall, this is a great product for data visualization.
Pros
- Power B1 allows you to pull data from a variety of sources for your analysis. Examples of this sources are Microsoft SQL, Excel, Oracle Database, HANA database, MYSQL database, etc - In my career as a SAP Consultant, Power B1 comes in very handy especially for clients we implement SAP Business one with the SQL Database option. Power B1 helps the decision makers of a company to view their data in easy data visualization objects like KPI's and Dashboards.- The application has a general user friendly interface and many users can easily interact with it.- The fact that it easily integrates with other Microsoft Products like Azure and QL server is a huge plus. - It also offers data cleaning functionalities, helping you to to work with cleaner data for more accurate insights.- You can use Power B1 both on cloud and on premise as per your preference.
Cons
- There is a little bit of a learning curve involved if you want to get comfortable in deploying more complex features of Power B1 and making maximum use of it.- The license cost of Power B1 may not be viable to everyone who might want to use it.- When dealing with very huge data sets, Power B1 may not be the best option. You might need other more powerful data visualization tools like HANA database.
- Industry: Management Consulting
- Company size: 201–500 Employees
- Used Daily for 6-12 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 2.0 /10
A pretty reporting tool for some (!) Microsoft Products, but pretty much useless outside of...
Reviewed on 18/03/2017
In light of the hype around this "Tableau destroyer" in recent months, I want to highlight some...
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

- Industry: Internet
- Company size: 51–200 Employees
- Used Daily for 1-5 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
Strong visualization platform
Reviewed on 28/07/2023
Experience with Microsoft Power BI was really good and their support is a strong plus
Experience with Microsoft Power BI was really good and their support is a strong plus
Pros
Microsoft Power BI is very versatile with creating dashboards and reports. Controlling access levels is efficient
Cons
Microsoft Power BI is not that easy to use when compared to Looker. Looker has stronger features and capabilities.
- Industry: Dairy
- Company size: 201–500 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
An analytical tool for business analysis and understanding.
Reviewed on 26/10/2023
Getting to know how pur business is performing has been a great achievement and we give all the...
Getting to know how pur business is performing has been a great achievement and we give all the credit to Microsoft Power Bi. It has been super productive to us. With Microsoft Power BI, we have been able to analyze our business operations and relate the insights we get with our initial goals and this gives us a clear working point to help us focus on improving our performance.
Pros
Microsoft Power BI has very powerful analytical tools which makes it possible to run full analysis on our business in order to understand our performance and the position we are at comparing it to where we want to be. The reports are easy to read and interpret and has very accurate insights about our business. It makes it so easy for us to pull business data from all over our working infrastructures in order to have a full review of the entire business operations.
Cons
Personally, i didn't find it much easier to use but am glad i was able to get assistance from the available self support articles.
- Industry: Computer Software
- Company size: 501–1,000 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
Simple reports creation for any kind of business process reporting
Reviewed on 06/10/2023
Easy to learn and integrate your various sources system process and create meaningful report for...
Easy to learn and integrate your various sources system process and create meaningful report for monitoring and analytic purpoe.
Pros
dashboard creation, within one dashboard it will be multiple kind of reports for same pivoted data set.
Cons
Data integration with API's sometime error could not be identified easily.
- Industry: Consumer Goods
- Company size: 10,000+ Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 8.0 /10
Great Data Analytics
Reviewed on 20/09/2023
Overall my experience is great, it works fine.
Overall my experience is great, it works fine.
Pros
I really liked to integrate our internal data sources together and create complied reports.
Cons
Although it's great, some of the connections are not available, that needs to be improvement.
- Industry: Medical Devices
- Company size: 501–1,000 Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 10.0 /10
Data analysis made simple
Reviewed on 30/10/2023
Pros
Whether you're a data expert or a beginner, Power BI caters to all skill levels, and its learning curve is very short and simple.
Cons
Could be hard to use to none tech-savvy people. It does require some training.
- Industry: Insurance
- Company size: 1,001–5,000 Employees
- Used Weekly for 6-12 months
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 8.0 /10
Easy for your job.
Reviewed on 06/11/2023
Pros
If you are a data analyst like me, this software is a must have and a skill to learn too.
Cons
It's little hard when you try to change from another software like Tableau.
- Industry: Computer Software
- Company size: 51–200 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Likelihood to recommend 10.0 /10
The visualization and analytics product that is constantly evolving - for the better
Reviewed on 07/02/2020
With Power BI we identify patterns, issues and opportunities in sales, marketing, operations,...
With Power BI we identify patterns, issues and opportunities in sales, marketing, operations, supply chain, people management and finance data. The ways to look at the data and the drilling capabilities make this a wonderful tool
Pros
1. Improves with new releases every two weeks
2. Powerful insight management
3. Integration with MS products
4. Online forums and learning zones
Cons
1. Not as intuitive as packaged applications, but getting there
2. Not a good IDE for Python / R
3. Connectors to social media need to be improved
Reasons for Choosing Microsoft Power BI
Power BI is evolving faster and with better options and integrationSwitched From
SpotfireReasons for Switching to Microsoft Power BI
Deeper integration with Microsoft tools online and offline.- Industry: Hospital & Health Care
- Company size: 5,001–10,000 Employees
- Used Weekly for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
Really good for aggregating data from multiple sources
Reviewed on 15/01/2020
Power BI has helped us go from random spreadsheet reports to consolidated dashboards that are...
Power BI has helped us go from random spreadsheet reports to consolidated dashboards that are pleasing to look at and easy to interpret.
Pros
The interface is beautiful and easy to navigate. Once data sources are all connected, it's pretty easy to create a new dashboard/layout if you know how to analyze your own data. Nearly every integration that we needed was already included.
Cons
It's hard to build some more complex reports. If you want to combine two different data sources into one view/metric, you will need some advanced skills.
Reasons for Choosing Microsoft Power BI
We switched from our basic Excel reports because they weren't very good, they were hard to update, and they didn't include a lot of useful information on each screen.Switched From
Microsoft ExcelReasons for Switching to Microsoft Power BI
We are fairly well integrated into the Microsoft ecosystem and Power BI integrates well with the other tools we use. It offered the best balance of features, maturity, and value for our needs.- Industry: Design
- Company size: 10,000+ Employees
- Used Daily for 6-12 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
New to Power BI but love it
Reviewed on 03/12/2019
Overall I love the software and would highly recommend it. Not only does it help visualize data...
Overall I love the software and would highly recommend it. Not only does it help visualize data but also helps to keep it updated in real time with the ability to connect to a server. The automation of pulling the data on a schedule and importing it directly into the visualizations solved a huge problem for our company.
Pros
I love how easy it is to make really powerful visualizations. The ease of use in order to basic visualizations is similar to Pivot tables in Excel. If you have a basic understanding of Pivot tables you will be able to open the software and get straight to visualizing. Once you take a deeper dive into the queries and data transformations you will uncover an entirely new world of analysis.
Cons
The software is easy to use for basic functions but when you get into more detail it can be difficult. It is also really hard to share your work with someone that does not pay for the service. Without paying for a Power Bi Pro account it is basically impossible to share the visualizations that you have created. Also, the Arc GIS feature only works within the software. If you try to post a map visualization to a website through an embed it doesn't work.
Alternatives Considered
TableauReasons for Switching to Microsoft Power BI
We chose Power Bi because we had an enterprise with Microsoft already.
- Industry: Tobacco
- Company size: 501–1,000 Employees
- Used Weekly for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Ugly numbers to pretty pictures
Reviewed on 13/06/2020
Management loves it, I love developing with it but getting certain others to adopt it can be a bit...
Management loves it, I love developing with it but getting certain others to adopt it can be a bit of a challenge.
Pros
As the title says, it turns ugly numbers into pretty pictures. It is easy enough for a non-developer to use and turn a mess of data into an intelligent and understandable story.
Cons
It literally changes every three months. You just get used to it and with the next update a lot has changed. I don't really see this as a con though because this is more like a Christmas present waiting to see what they will have made better this go around.
Alternatives Considered
TableauReasons for Choosing Microsoft Power BI
When preparing charts in MS Excel you wind up with too many human errors and you have to have someone who really knows excel to build great dashboards.Switched From
Microsoft ExcelReasons for Switching to Microsoft Power BI
Cloud based, integrated with other Microsoft products and it was first to have a huge amount of AI integration and capabilities.
- Industry: Government Administration
- Company size: 1,001–5,000 Employees
- Used Weekly for 6-12 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 7.0 /10
Excellent tool for small offices and datasets but can lead to frustration overtime
Reviewed on 14/03/2021
I am generally satisficed with the product, price and ease of learning with lots of YouTube video ...
I am generally satisficed with the product, price and ease of learning with lots of YouTube video and the Power BI community, there is always something new to learn and implemented to improve or help meet your reporting requirements.
Pros
Easy to get started with Power BI if you are on the Microsoft 365 platform. Power Bi provides an easy to connect and interactive method for pulling data in real time from data collection system such as the SharePoint online, MS Excel and others. The ease of connecting with SharePoint is the strong point for my review.
Having the Power Bi connected to the SharePoint system provides the opportunity to have real time dashboards and dynamic reports for any small organization that is wishing to provide real or near to real-time reporting without the heavy upfront implementation cost for software, training and human resource.
Microsoft has indeed liberated the Dynamic Reporting with Power BI, and has also allowed for some very elegant web reporting to be created by non technical users.
My simple work flow , SharePoint for data collection, PowerBi for reporting.
Cons
The main issues are around the changes that are made by Microsoft, this will always be a learning curve for the users.
The lack of consistency on certain actions will be the biggest issue.
Alternatives Considered
TableauReasons for Switching to Microsoft Power BI
Cost, Familiarity and given that is is a free offer within the MS Offfice 365 or M365 platform, it leads to an easy choice.- Industry: Information Technology & Services
- Company size: 2–10 Employees
- Used Weekly for 6-12 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
Outstanding Report Tool
Reviewed on 09/06/2021
Having switched from excel recently, Microsoft Power BI has been of great help. Having good visuals...
Having switched from excel recently, Microsoft Power BI has been of great help. Having good visuals for data is a plus to us as an organization for they help do comparisons at a glance.
Pros
The ability to do data linking from different data sources and doing relations and end up developing organized and analyzed data for easy decision making.
It provides the ability to break down data to a level that is easy to understand.
The creation of dashboard in Power BI makes the reports appealing and data presented friendly to interact with.
Cons
Loading Microsoft power BI takes quite some time especially the desktop version. I don't the reason behind it but it could be better if it is looked into and a solution found will be of great help.
Alternatives Considered
TableauReasons for Choosing Microsoft Power BI
Microsoft Power BI makes work easier for it has features that Microsoft Excel does not have.Switched From
Microsoft ExcelReasons for Switching to Microsoft Power BI
Microsoft Power BI has added features that our organization required.- Industry: Telecommunications
- Company size: 501–1,000 Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 9.0 /10
Analytic Superman
Reviewed on 12/02/2021
Power BI has been a game changer for us when it comes to how we see and break down the analytics of...
Power BI has been a game changer for us when it comes to how we see and break down the analytics of our business. Its a platform that integrates all parties to one sheet and allows us to break the data down visually and analytically. Only drawback is when you need to make an update it could take the builder some time to update.
Pros
I love the way Power BI is able to show the data in a very eye friendly way. If you have a business that has markets, districts, and locations that need to show data then Power Bi allows you to break this down to any analytics you need to see with graph representation. Its great!
Cons
It does take some knowledge around formulas and excel. If you don't have an analytic data team that can make these repots for you on Power BI then it will take you a longer time to see the analytics from it.
- Industry: Research
- Company size: 11–50 Employees
- Used Weekly for 6-12 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Likelihood to recommend 8.0 /10
The Ultimate Data Visualization and Analysis Tool
Reviewed on 18/12/2022
Power BI is a powerful and popular tool, it may not be the best fit for everyone, depending on...
Power BI is a powerful and popular tool, it may not be the best fit for everyone, depending on their needs and budget. Power BI is a powerful and flexible tool for data visualization and analysis that is widely used by businesses and organizations of all sizes. Its ability to connect to a wide range of data sources, and to collaborate and share insights with others, make it a valuable tool for anyone working with data.
Pros
One of the best features of Microsoft Power BI is its ability to quickly and easily connect to a wide variety of data sources, including Excel spreadsheets, databases, cloud services, and online services. Power BI can pull data from these sources, process it, and visualize it in a variety of ways, including interactive charts, graphs, and dashboards.
Cons
Power BI can be complex and overwhelming to learn, especially for those who are new to data visualization and analysis. Power BI includes a wide range of features and tools, and it can take some time and effort to become proficient in using them all.
Alternatives Considered
TableauReasons for Switching to Microsoft Power BI
Power BI is generally considered to be more affordable than Tableau, especially for smaller organizations or individuals. Power BI is available in several pricing tiers, including a free version that includes many of the basic features, while Tableau typically requires a more expensive subscription.- Industry: Education Management
- Company size: 201–500 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
Enhancing University IT Systems with Microsoft Power BI
Reviewed on 17/08/2023
Microsoft Power BI is widely regarded as a powerful and versatile tool for data visualization and...
Microsoft Power BI is widely regarded as a powerful and versatile tool for data visualization and business intelligence. Its capabilities in transforming complex datasets into interactive visualizations and reports are highly appreciated by professionals across various industries.
Pros
Power BI allows for easy sharing of reports and dashboards with colleagues and stakeholders. This promotes collaboration, as everyone can access and interact with the same data. The interactive features of Power BI dashboards enable users to drill down into data, apply filters, and explore different aspects of the dataset. This interactivity enhances data exploration and analysis.
Cons
Data Refresh Limitations, Limited Offline Access, Advanced Analytics Requires Expertise. Power BI heavily relies on online connectivity for data retrieval and sharing. Offline access to reports and dashboards is somewhat limited, which can be a concern in certain scenarios.
Alternatives Considered
Tableau- Industry: Banking
- Company size: 1,001–5,000 Employees
- Used Weekly for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
It brings the power of BI down to non-tech users
Reviewed on 26/08/2019
My job is to collect and process all sorts of data in my organization and present them to the...
My job is to collect and process all sorts of data in my organization and present them to the highest management committee for policy level decision making. We are heavily dependent on MS Excel for this. I handle excel worksheets with thousands of entries every day. A year ago, I tried Power BI to see whether it can help me in my job or not. And i am hooked till now. I am most impressed with the processing power of Power BI. Huge worksheets can be processed very fast using Power BI. It also updates the reports automatically which improves my productivity significantly.
Pros
1. Ease of Use: Unlike other BI software’s, Power BI's interface is friendlier especially to MS Excel users. You will not feel overwhelmed rather it will look familiar.
2. Powerful engine: Users who need to tackle very large datasets with thousands of entries know that MS excel gets horribly slow processing such a large file. Power BI is a God sent for these users. Its processing engine is super-fast and the speed is more noticeable when you let it handle such large datasets.
3. Excellent data presentation tools: For regular MS Excel users Power BI is a PowerPivot on steroid but a lot smarter one. Even those users who are not familiar with the complexities of PowerPivot feels less intimidated by its simple and user friendly design.
4. User friendly but powerful DAX language: To write formulas you have to use DAX language in Power BI which in my opinion is a fancy name of just natural language formula writing. However, DAX is super easy to learn and pretty much intuitive but at the same time very much powerful.
5. Schedule refresh option: Power BI has an option to auto update the report at fixed interval of time which is very helpful if you need to prepare and submit reports weekly or monthly.
6. Option to control users of the report: In Power BI you can share your reports with other users and also control how much of the report can they see. If you want you can allow only a part of the report to be seen by some user which is super convenient.
Cons
Honestly, in my opinion, Power BI is by far the best software made by Microsoft. But considering I am a heavy user of MS Excel, it is easier to me. I think learning curve of Power BI for a beginner with no prior skill in MS Excel will be a bit steep. Then again, BI is a complex thing itself. So master any kind of BI software will be tricky by its own merit.
- Industry: Real Estate
- Company size: 2–10 Employees
- Used Weekly for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
Power BI ; Affordable Data Visualization Tool
Reviewed on 04/05/2021
It is an affordable software that enables us to consolidate our data, generate reports while...
It is an affordable software that enables us to consolidate our data, generate reports while keeping track of all the key performance indicators.
Pros
It is a good data analytics and visualization software and its ability to import data from multiples sources is a great feature.
What I like about Power BI is that from the dashboard, we are able to get a great overview of the organization including the market analysis, the status of our current deals, track the performance of each team member, view the gross income and company financials.
The ability to filter to the specific metric we are interested in is an amazing feature. It enables us to review our marketing expenses and also see how each team member's activities contribute to the bottom line. It is also easy to forecast cash inflows and outflows.
Power BI makes it possible to customize the visualizations and it also has the option to upload and view data from Excel.
Frequent upgrades from Microsoft keep Power BI functioning well.
It has both freemium and premium versions. You can try it out and have a feel of the software before you choose to purchase it.
Cons
It can be a bit complex due to the fact that it is a collection of various tools and you have to learn what each component does and how it relates to the rest of the structure.
Working with large data sets causes lags especially when on the free version. The free version has very limited features and doesn't give you the true performance capability of the software. This can however be solved by upgrading to Pro or Premium.
The user interface is a bit crowded with too many icons which hinders a clear view of the dashboard.
- Industry: Information Technology & Services
- Company size: 201–500 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
A really useful tool for us in our quest for the best analysis to find the best solutions.
Reviewed on 04/03/2022
When you use Microsoft Power BI, you can automate most periodic reports and reduce the amount of...
When you use Microsoft Power BI, you can automate most periodic reports and reduce the amount of time it takes to prepare those reports. As a result, we have been able to rely on it at all times and use it for a variety of different analysis procedures and duties. It's a great aid in our search for the most accurate solutions.
Pros
Because of its multiple options and tools for analyzing and organizing data, Microsoft Power BI is software that empowers businesses. Business teams may use it to produce all aspects of business intelligence projects, from the initial concept to the final representation. The platform is user-friendly and can import and export data from a wide range of other apps, making it ideal for people of all skill levels. Data exploration, discovery, and visualization are made easier for non-technical managers with Microsoft Power BI, which allows them to access reports and dashboards without any training. To acquire the best outcomes, everyone involved can work together more closely because the data is saved on the cloud. All Microsoft Office programs, including Excel, can be used to build an interactive data dashboard. Microsoft Power BI may be used to turn an Excel spreadsheet into a database, and PowerPoint can be used to display, store, and share the data.
Cons
Power BI requires extensive training for all members of the team, but if you have the appropriate skills, it is a superb tool for extracting the most accurate data.
- Industry: Human Resources
- Company size: 11–50 Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
The best gets better
Reviewed on 06/10/2020
It's easily the most feature rich overall. Other products like Tableau and Qlik have their...
It's easily the most feature rich overall. Other products like Tableau and Qlik have their advantages, but I'm hard pressed to find much fault with Power BI, other than the premium licenses being ridiculously expensive. The word is Microsoft is addressing that issue later in 2020/2021.
Pros
The features and ease of creating visualizations are top notch. Also integration with all other Microsoft products as well as pre-built connectors to many of the most popular software is hard to beat.
Cons
There are many features not available unless you pay for expensive premium capacity.
Alternatives Considered
TableauReasons for Choosing Microsoft Power BI
We needed more advanced analytic solution.Reasons for Switching to Microsoft Power BI
Features, pricing, community support.- Industry: Government Administration
- Company size: 501–1,000 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
BI tool with the coolest features
Reviewed on 14/12/2018
I have been using PowerBI from the past 3 years and have never looked back. It has helped me as an...
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.

- Industry: Computer Software
- Company size: 10,000+ Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
User-friendly and with a relatively quick dataset load time, data-driven business insights
Reviewed on 18/12/2022
Pros
The greatest business intelligence and data analytics software is Microsoft Power Bi Desktop, which guarantees that accurate data-driven insights are retrieved for corporate decision-making and smooth implementation. We can analyze, analyze, and even build dashboards using data in a variety of formats that have greater processing capability for rows and columns than Excel. Additionally, the visuals are considerably more exquisite and diversified. When I get stuck with DAX code, Power BI community articles and the DAX language's simplicity come in handy. Power BI is far more user-friendly and intuitive, in my opinion. I would strongly advise any organization seeking a BI solution to use this.
Cons
Power BI's inability to produce bespoke infographics as quickly as Tableau is its main drawback. Direct connections may be made between Power BI Desktop and PostgreSQL DB. However, we are unable to directly link PostgreSQL DB with the Power BI service. Additionally, the cost of the program has to be drastically reduced so that more small and underutilized enterprises may benefit from it and use its features to their best potential.