Microsoft Power BI Reviews

There are several different use cases. The most basic use case would be just to be able to share data from a database or a data repository. That's the most basic use case.

Microsoft Power BI is a visualization tool, is a BI tool. There are more than 1,000 use cases that you could use. There are countless use cases for which a BI tool or visualization tool could be used for.

The simplest use case is where a colleague in an organization who does not have any coding skills or does not have any technology background wants to be able to look at some data from a database or a repository of data. He or she could use Power PI just to be able to connect to that system and just take a look at or peek into that database. It is as simple as that.

Over the last six years, Microsoft Power BI has evolved, matured, has brought in a lot of new features. Six years back, when I first started using Microsoft Power BI, it was just one of the tools among the crowd of tools that I had access to and may not have been that interesting, at that point in time. It was fairly rudimentary and fairly basic in terms of its feature capabilities. However, in the last six years, Microsoft has put a lot of focus and effort into developing it further, and has, on a regular incremental basis, started deploying and enabling capabilities and features, which now makes Microsoft Power BI one of the leading BI tools in the industry.

We realized the benefits very quickly. In 30 minutes, a company can begin to realize the benefits.

In the most basic use case, which is for a user to be able to just access a data which he or she normally would not have been able to himself or herself, since they don't have SQL query knowledge, or they don't know how to access, log into a SQL Server or a database. They can do that using Power BI within half an hour or less.

Like any typical BI visualization tool, Microsoft has several features. The most interesting feature of Microsoft Power BI is that it's very user-friendly.

It is a cloud-based BI tool even though it does come with a desktop client. The ability for a very beginner, basic user to get started with Power BI is very easy. Even if you don't have Microsoft licenses and just want to use a tool for analyzing data, without having to share it with others, you can do that with Microsoft Power BI.

I'm comparing this with other existing and newcomer BI tools. The look and feel of the tool has, only like a month back, undergone a major change. If not, for the last five years at least, last four years at least, the look and feel have been very, very similar all the time. 

It did not change much in the last four years. Barring a lot of functionalities and capabilities being added, it did not change much. The look and feel were pretty much the same. However, about a month back, the latest release of Power BI, they made some further, drastic changes to the way the buttons and the panels are set up. That said, they can do more. There are still better UI designs they can go through. I'm assuming they are focusing more on capabilities rather than look-and-feel designs.

I've used the solution for six years now. 

The solution is quite stable and we have not had any, not come across significant bugs, so far. We've only come across some features which are missing or could have been improved, like certain types of charts that were missing in the past, which are being added. Some of the advanced charts are available as a paid service from third-party partners and not available out-of-the-box. There are very unique features or some very specific capabilities that were missing or are still missing. We could always manage it by bringing in a partner to create an add-on or something like that.

The solution is very scalable and we do plan to increase usage. 

We haven't opted for technical support yet as we have a few other tools which are also being used by the organization, in the new organization that I'm in, right now. Power BI was being offered to colleagues to use on a self-service basis. There were communities and subject matter experts within the organization who had offered their services to the wider organization to come and ask questions. It was basically community-based support, I would say, within the organization. 

Also, Microsoft offers free community-based support for Power BI and proactive support is simply paid. It's paid service from Microsoft and other partners, so we have not opted for that yet, something we will look into once it comes to that point. Yet, it's a fairly mature product. We don't think there would be issues with the platform. The issues would be more to do with how to use the platform, or how to use the platform in conjunction with other systems, other software, et cetera, which is more specific to our organization rather than something the vendor has to support us with.

You do get your questions answered eventually, however, you have to wait maybe one or two days to get the questions answered.

Positive

I have used more than ten to 15 different types of software in the past 20 years.

I have used Tableau and I have used Qlik Sense. These two are, I would say, the top two leading platforms. We switched completely to Power BI, however, we started using Power BI more, alongside Tableau and Qlik Sense. The organization where I used to work previously had the commercial ability to acquire multiple software, depending on use cases, or depending on business requirements, or needs. In the previous organization, the organization was using one particular platform, then they decided to bring in a second platform, then they decided to bring in the third platform. As part of that mix-and-match scenario, we ended up using Qlik Sense and Tableau. And then we also started, in parallel, using Power BI, which then started to get better feedback and reviews, in general, so we ended up using it more and more.

It comes bundled with Office 365. Office 365 is a SaaS-based office suite. Anything that you build on your desktop or Power BI, you can publish into the Office 365 cloud environment. It's relatively easy to get everything up and running. 

It's as simple as taking your credit card and buying an Office 365 license and configuring the AD group and you can be up and running. Of course, depending on how secure and structured you want to make your entire setup, it can take a few months, sometimes, with the full rollout to happen. 

A very basic pilot rollout can be done in a matter of a few weeks.

For the actual deployment and configuration, we just needed five people, and five resources working between six to 12 months. Some were required only for six months. Some are still continuing as part of further enhancements as some of the resources are being retained from a training and onboarding purpose so that they can do a training of the wider organization, and colleagues in the organization, show them how to use Office 365, and get trained on that. The actual development itself took less than two or three months.

In terms of maintenance, there are regular patch updates that get pushed from Microsoft. The backend IT support team needs to ensure all the patches are tested before they're deployed in production, for all the users to use.

Microsoft usually sells through a partner, most of these licenses, and Microsoft also usually recommends a partner. In our case, we did an RFP to bring in the subject matter experts, partners who are certified on Microsoft platforms.

We had a system integrator who came in and helped us deploy and roll out Microsoft 365. As part of that, as I mentioned, we got Microsoft Power BI. 

We are now thinking if we should switch on all the other capabilities of Microsoft Power BI or not.

We have noted an ROI, however, it varies from use case to use case.

There are some use cases in which if you deliver it, the cost savings or the revenue generated from that, or the benefits from that one single use case will cover the entire cost of all 65 licenses, for the entire year.

Then there are use cases, in which you'll have to wait for a few years or months before a company will actually see some benefit being derived.

They have made the desktop client free of cost, which is also what Qlik Sense is. The Qlik Sense Desktop is free of cost. Tableau, the web version of Tableau online, there's a trial period you can use it for. Microsoft also has made Power BI available as a free add-on, or a free complimentary add-on alongside Office 365 for corporate users. This means even if the organization does not want to use Power BI, if they're using Qlik Sense, Tableau, Looker, ThoughtSpot, Domo, or the other tools, Power BI will still be available to them when they're using Microsoft Office.

While it comes bundled with Office, you don't have to buy any additional licenses, just for building and publishing. That said, the moment you want to start sharing your reports, your dashboards, and your analysis with others, that is the point where you need to then start paying for additional capabilities or plans.

I've always been part of different transformation programs where we were required to evaluate a BI tool, to meet the business requirements. Usually, Power BI ends up coming in the short list of products from a BI perspective, from a BI reporting perspective, apart from sometimes Tableau, and Qlik Sense. Sometimes, we also come across ThoughtSpot, Sisense, and Domo. These are some of the other tools which we have also, sometimes, shortlisted.

The differences have become very, very minimal between solutions. There are very few, minor differences between different tools. About four or five years back, there used to be drastic capability gaps between the different tools. Four or five years back, Tableau was the most mature, followed by Qlik Sense, followed by MicroStrategy, followed by a few other tools like SAP Analytics, or a few others. Today, Power BI is alongside Tableau, and Qlik Sense is in the top three. That's based on my experience of having worked on all these three platforms. Tableau, among the three, has the best UI, user interface. Qlik has the best performance, in terms of building complex data models. Power BI, however, is the easiest and most fun to use when it comes to getting somebody to use the tool from scratch. 

There are a few other benefits and strengths. Qlik Sense and Power BI, both come with built-in ETL which is data integration capabilities. They have very mature data integration capabilities, as compared to Tableau, whereas Tableau has very basic integration capabilities. You need to buy another ETL product for it to be able to do a similar level of data transformation as Qlik Sense, or Power BI.

We are a customer and may also be a Microsoft partner, as we are a telecom. 

I'd rate the solution nine out of ten.

A client used Power BI mainly for banking reports. Another client was working in the field of laboratories, and they requested Power BI for the analysis of laboratory-related data for COVID-19. There were also some use cases where we used predictive analytics or utilized the power of Power BI services in the cloud.

It can be deployed on-premises and on the cloud.

It helps in automating the process of filling the data or refreshing the data to give you timely calculations for all the aspects of the dashboards that you have built. You can easily see all the real-time data with Power BI.

The good part of it is that you can do whatever you want with it when it comes to building BI. In terms of languages, it supports Python, and it also natively supports R.

You can integrate it with the cloud. On the desktop level, you just install the desktop installer, which is about a hundred megabytes or something like that, and it connects to the cloud. So, on the desktop, you can utilize the cloud power for AI and machine learning to help you with predictive analytics.

Most of the dashboarding tools have prebuilt graphs. So, you have to stick with them, unless you are going to use a third-party tool to create them, and then you are going to upload them to the BI tool. In Power BI, they started supporting this functionality and created a tool for that, but it isn't yet complete and mature. It is still exceeding the expectations and is better than most of the BI tools when it comes to creating custom graphs, but it needs more enhancement and simplification. It would be good to have a design tool provided by Power BI to design the graphs that we want and set the figures that we want on them.

I have been using this solution for six years.

It is stable. Solving dashboard issues on other products, such as Oracle, took us a lot of time, whereas solving issues in Power BI was so simple. The language they're using is also easy. In Power BI, you use the DAX language, which is derived from Excel. So, anyone who knows how to write Excel code would know how to deal with Power BI. It is going to be so simple.

The cloud version is scalable.

It is super easy to set up. I've been giving training on this to new employees, and they quickly learn how to work with the whole product. It doesn't take them more than one or two sessions.

The installation of Power BI Desktop on a computer takes a maximum of 10 minutes. You just have to install it on the computer, and that's it. Most of the services are over the cloud. When you do the subscription, you just connect or sign in with your company email address that has been registered, and that's it.

The on-premises version requires extra staff. It requires an engineer who knows how to implement AI algorithms and then connect them to the offline Power BI solution.

Power BI is subscription-based, and you have three options. The Pro edition, which is the standard one, is about $9 per user. The Premium edition, which provides AI and cloud capabilities but at a limited size, is for small to medium enterprises. It is about $20 per user. For large enterprises, such as manufacturing facilities, there is an option for the capacity. The capacity subscription is about $4,000 per capacity level.

They also have an option for the on-premises version, but it is not common to see someone going for the on-premises version. The on-premises version requires a specific license that is attached to SQL Server. I believe it is about $17,000, but I'm not sure about it.

It has an on-premises version as well as a cloud version. I usually recommend people to work with the cloud version. In the on-premises version, if they want it to go with the artificial intelligence part, they are going to require engineers to configure it, whereas it is already there in the cloud version. It is already configured and affordable. The cloud version costs between $9 to $20 per user, which makes it very affordable, and you also have the capacity option, which costs about $4,000 per month per capacity. The capacity option is usually for huge enterprises. Regular companies, even banks, can work efficiently with the cheapest option, which is $9 to $20 per user.

After working with Power BI, I would rate it an eight out of 10. There is huge competition in the market when it comes to BI tools, and there are fractional differences between Power BI and some of its competitors.

I use Microsoft Power BI for data visualization and IT studies. It is used primarily in my academic studies and courses, particularly in my visualization course, which is part of a master's program for individuals currently working in the industry. Students also use similar programs like Excel to monitor various issues.

Using Microsoft Power BI has significantly helped in analyzing large datasets. The solution allows for visualizing and connecting different Microsoft applications, which is beneficial for academic purposes.

The best features of Microsoft Power BI include its integration with other Microsoft products and its ability to connect applications within the Microsoft ecosystem. The product's overall integration within Microsoft's ecosystem is one of its strong points.

There are a few areas where Microsoft Power BI could be improved. For instance, spatial data support should be enhanced. Currently, it supports only topoJSON format for spatial files; other formats such as shapefiles or KML should also be supported to broaden the library.

I have been using Microsoft Power BI for at least five years.

The stability of Microsoft Power BI is quite good. I would rate it a nine out of ten. However, there can be some difficulty in handling very large datasets, but overall, the stability is strong.

Dealing with very large datasets can be a bit difficult, which impacts the scalability to some extent.

I would rate Microsoft's customer support a seven out of ten. This rating may be influenced by my location in Turkey, making access to support somewhat challenging.

Neutral

I have used several other solutions, including Tableau and Looker. Each has its advantages, but generally, I prefer Microsoft Power BI first, followed by Qlik, and then Tableau.

The initial setup of Microsoft Power BI is straightforward and can be managed without significant issues. Using it for academic purposes, we mainly use the desktop version.

For companies, the program is cost-efficient. Academically, we use Microsoft Power BI for free through the licenses provided.

I evaluated Tableau, Looker, and Qlik before deciding on Microsoft Power BI. Each of these solutions has its own unique advantages.

Given the increasing need to analyze large datasets, I would definitely recommend Microsoft Power BI. It is a valuable tool for both academic and practical applications, particularly for those involved in data analysis and IT studies.

I'd rate the solution eight out of ten. 

We use the solution to build business intelligence dashboards.

The solution's most valuable feature is the graphic representation.

The dynamic browsing tables could be better in Microsoft Power BI.

I have been using Microsoft Power BI for three years.

I have not faced any issues with the solution’s stability.

I rate the solution an eight out of ten for stability.

I am satisfied with the solution’s scalability. Our customers for Microsoft Power BI are enterprise businesses in the engineering sector.

I rate the solution’s scalability ten out of ten.

Microsoft Power BI is a simpler solution than Tableau.

The solution's initial setup is easy. The solution can be deployed in a few hours.

On a scale from one to ten, where one is difficult and ten is easy, I rate the solution's initial setup ten out of ten.

Microsoft Power BI is a comparable tool that provides very quick ROI, and it's as good as or better than other products like QlikView or Tableau.

Microsoft Power BI is not an expensive solution. The solution’s pricing is reasonable.

The solution's real-time data processing feature benefits our organization because most managers want to have real-time data compilations. They want to integrate SQL and expect the data to be current. Different clients have different environments. Sometimes, the tool is deployed on the local server, and sometimes in the cloud.

Microsoft Power BI is worth trying because it's very popular and easily adopted by organizations. It's easier to adopt than third-party products. Microsoft Power BI provides good graphical overviews, good graphic preparation of data, good integration with SQL, and good data integration.

Overall, I rate the solution an eight out of ten.

We have many projects in the company. Some of them are self-service where they can connect on their own to local on-premises databases. Some of them are with big databases on the cloud, such as Azure SQL or Azure Synapse, and some of them are with local sources, such as Excel files, etc.

It is really flexible. The charts and reports are really nice. You have the flexibility of self-service.

It is not yet ready for enterprises. For a big enterprise data model, it is not so stable, and it also doesn't scale so well.

I am not really satisfied with their support. Their support should be faster. They should also be more knowledgeable.

I have been using this solution for two and a half years.

It depends. It is not really for enterprises. Even though Microsoft is trying, it isn't yet ready for enterprise use. For self-service, it is pretty fine. If you don't have a huge data set, it is quite stable.

If you try to have a big enterprise data model, it doesn't scale so well. You wouldn't get results similar to some of the other on-premises tools.

In terms of its users, I don't know the exact number, but we have about 10,000  to 20,000 users. Its usage is increasing.

I have contacted them a lot of times. I am not really satisfied with their support. Lately, it has become even worse. They are probably overloaded, and it takes really long. Many times, they just say, "That's how it works." In reality, it is a bug.

Many times, their first-level support doesn't understand what the problem is, and they don't reach out to the proper people to get into the issue. It is not really good.

We have been using different tools, such as QlikView, on-premises OBIEE, Tableau, Excel, etc. We are trying to migrate almost everyone to Power BI. So, eventually, we will have only Power BI. Its usage is growing.

It is really easy. It is mostly automated. You simply publish the dataset. 

It doesn't take too long. It takes about 5 to 10 minutes.

I'm a part of the team that manages all the projects that are done with Power BI within the company. We guide them and help them with the development and all the architecture.

The number of people required depends on the size of the project. For one of the big projects we have, there are a couple of developers. There is one person for the management of Power BI. We also have 10 to 12 people doing the reports, etc.

We have premium licenses, but you can use it for free. You can share the content with anyone else, so you can use it for free.

I would recommend it, but if you want to use it enterprise-wide, you need to be really careful because you might face problems. In general, it's really a great tool. For self-service, it is more than okay, but when you try to use it enterprise-wide, it doesn't really work well.

Overall, I would rate it a seven out of 10.

We have created the reports and are continuing to work on them. We are deploying them to the proxy, and the users are utilizing them for various business processes.

I work in Tableau or Tableau and Power BI. It can handle large data sets. You can just get the raw data. When it comes to Power BI, if you have to get the raw data and want to refresh it, the refresh at a point in time would degrade performance.

One of the key benefits of Power BI is how easy it is to develop reports. Even non-technical users can easily download the report and learn to include slicers and data filters once provided with a template. The platform is very user-friendly. Another advantage of Power BI is that if the report developer encounters any issues, they can quickly find solutions through Microsoft’s help resources. You can get your assistance by visiting the Microsoft support site or posting queries. This makes developing and delivering reports much easier. Microsoft Power BI provides much support and flexibility, making it a great tool for report generation.

It can integrate with different data sources. You can connect seamlessly to Databricks, SQL Data Warehouse, third-party sites, and multiple other sources.

We identified a couple of issues in the reports. Some reports took too long to load, particularly at the end of our data refresh. To address this, we optimized the data model using multiple tables, improving performance. Now, all reports are refreshing properly using DBP, and we’ve implemented these improvements in Power BI.

I have been using Microsoft Power BI for two years.

The availability of Power BI is excellent. Once a user is set up, they can easily access and work with the Power BI files from the repository. There are also various modes for adding features, allowing users to combine data in different ways to make informed business decisions. 

Based on business discussions, there are 25 to 100 business users. The users work with templates, and we collect UAT feedback from them.

The initial setup was straightforward. Based on the current requirements, I've been able to develop the reports independently. It's easy to use and allows for faster reporting.

Once we generate the reports, we schedule and publish them on the website and then share the process with the users.

We're able to refresh the Power BI reports and create data models to support the business at this stage.

I'm working with a company that manages detailed sales data for the clothing industry. We're tracking orders, brands, seasons, and which facility handled the order, along with audits. We're focusing on metrics like fabric consumption and fiber content for reporting. 

We can develop reports in Power BI, including RxTx reports. Many of the business teams are also using Power BI. For support, we use Slack to manage tickets and TableLab for some tasks. Power BI offers a trial version, and you can get a pro license at a relatively low cost, with users having access to AV accounts. The main advantages are that it’s easy to use and more affordable compared to other reporting tools.

Overall, I rate the solution an eight out of ten.

We use it specifically for pure data analysis. 

I like the speed of building a visual and the transformation feature where you can make changes to the data, and then revert back very fast. These features, where you make transformations and then delete that step when you don't need them, are some of the best.

Power BI's integration with other tools is very good. With Power BI, if there are other systems on the network, you can easily connect to anything like SQL Server, Oracle, Amazon, Salesforce, SAP...anything you can easily connect. I have not faced difficulties with that.

The real-time data refresh capabilities is one of the things I had issues with. The refresh sometimes doesn't really work very well because there are two ways of connecting: direct and import. 

When it's direct, it's refreshed, but then you have limitations. But when you import the data, I feel there is always a limitation in the refresh. It is kind of like a room for improvement for Microsoft Power BI to work more on these real-time data refresh capabilities.

Microsoft Power BI changes almost every month; make changes regularly. I sometimes even see features that disappear, change, and update. So, I'm not keeping up. They are already doing a lot of changes. They keep updating regularly.

I have been using it for six to seven years. 

It's quite stable. Power BI is very stable.

It is very scalable. Almost everyone in our company uses it. 

I personally use it daily. 

I don't usually deal with customer service and support. It's our technical team that deals with them, but I don't see them complaining.

I used Excel. Power BI can crunch the data faster, and you can build a dashboard nicer and faster. Building a visual in Power BI is always easier, quicker, and simpler than Excel. It's Excel on steroids. 

I used to use Excel pivot tables a lot, but with Power BI, it's faster. It's easier to play with the data. If I want to make a list or put some formulas and stuff, Excel is good. But if I want to visualize the data, crunch it properly, and build measures quickly, Power BI is better.

I would rate my experience with the initial setup an eight out of ten, with ten being easy and one being very difficult. 

It is deployed both on-premises and the cloud. 

The deployment time varies and depends on the company. Every company is different. Here, internally, we have Microsoft Power BI Cloud, so it's easy. 

But in the previous company, we did not have Microsoft Cloud. So, to install, we had to install Microsoft Reporting Server and then Power BI internally. That took quite a while. 

But if you have Microsoft Cloud in your company, that's easy. And it's quicker on the cloud than on-premises.

Maybe a third party helped with the deployment. 

Downloading Power BI Desktop is free. But when you want to use the cloud, this is where I think it's per user payment. I'm not really very familiar with the licensing because I think they have more than one level. 

But to use Power BI internally for yourself, it's free. You download it. It's a free application.

I would recommend Power BI to other people. Overall, I would rate it an eight out of ten. 

With Power BI, I create dashboards. We have an IT manager responsible for supply chain and CRM, including billing. I handle the supply chain module, receiving end-user requests for dashboards and reports.

I create analysis and measures in Analysis Services, then craft dashboards that meet end-user requirements.

My work involves using SQL Server Integration Services to integrate data from various sources, including Oracle and SQL Server, and then store them in Data Warehouse.

Power BI significantly organized our KPIs, making them accessible for immediate business decisions, like analyzing profits or losses. 

For example, in supply chain management, Power BI provides well-organized KPI data and calculated measures that aid decision-makers. Unlike before, they don't have to wait for detailed data; they get well-defined KPIs and calculated measures that offer insights into the business, allowing them to make informed decisions regarding future strategies and properties.

Power BI's collaboration functionality improves teamwork in our organization. We had a lot of entries and a lot of people who were working with Power BI. It's been four years, and some new members have less experience. We all collaborate to share information and experience, which improves collaboration.

Power BI's ability to integrate any data source, whether it's a cloud database, Analysis Services, or another type, is incredibly valuable. It allows us to make the right data available for analysis. 

Additionally, the flexibility to enhance our dashboards with new charts found online further helps with our analytical capabilities.

I also like the feature of the Page Navigator in Power BI. The Page Navigator allows users to navigate through different pages on the dashboard simply by clicking on the desired page, and Power BI will automatically open that page. 

Additionally, Power BI offers interactions where I can decide what Slicer or chart can filter another. Not all sources can filter all the others, and not all filters can be applied universally. 

I've also found Bookmarks to be a valuable feature, allowing for control over what sources are affected or whether they are visible or invisible during any interaction in Power BI. 

The dashboard and reporting features are very effective in decision-making. They enable decision-makers to determine the next steps, such as analyzing profits and losses, evaluating supplier performance, including late fees, and managing purchase timings in relation to delivery and order dates.

Data integration is very useful in Power BI. It lets me collect data from many sources, especially with IT support. I get data from tools, databases, data warehouses, and data lakes. For example, I can get data from Oracle databases and SQL Server databases at the same time.

We combine this data into a single destination—either a table or a database. This lets us analyze the combined data and create visualizations. Ultimately, we can consolidate information like customer details from different solutions into a single table. We can also change data types, clean the data, and organize it effectively.

When I create measures, sometimes the error messages aren't clear. It makes me spend more time searching for solutions. I need the error messages to be more specific.

So, I would like clearer error messages when creating measures.

I've been working with Power BI since January 2020, so it's been four years.

It is very stable. I would rate the stability a ten out of ten. 

It works well for a large number of users. We have almost 15 to 20 end users. 

I would rate my experience with the initial setup a four out of ten, with one being difficult and ten being easy to set up.

It's difficult to set up. Sometimes, I need technical support to resolve issues.

We use it on-premises.

The deployment time varies. Sometimes it takes two days, and sometimes it takes two weeks. If the dashboard has a lot of KPIs, it will take more time. Also, if the data already exists as measures, it's less complicated.

It's accessible with some subscriptions. We have a lot of users that we can send dashboards to daily, and that would cost a lot of money otherwise. But setting up Power BI itself is not expensive.

I would definitely recommend using this solution. It's easy to use. It can get data from a lot of sources. It's user-friendly. It's easy to learn, and it's easy to search on the internet for information about it.

Overall, I would rate the solution a nine out of ten.