Microsoft Power BI Reviews

I largely work with the engineering and R&D teams. Typically, the data insights and data teams use Power BI for business-related data visualization. However, for me and my customers, most of the tools like Power BI and Tableau are used to do data visualization for the engineering data. That could be even predicting the behavior of a machine, meantime between failure, or tracking of an IoT center data or even the behavior of the fleet management and things like that. In all the engineering use cases where we need data visualization, we use this product.

We have 16,000 to 17,000 or more people who are trained in insights and data. This group uses all the data analytics tools, data visualization tools, BI tools, and all the other tools from a business use cases perspective. It could be market basket analysis, sales reports, and all those kinds of other business reporting.

The solution has been stable.

We've found that the scalability meets our current needs.

It's good for data visualization and analysis. 

My understanding is that the initial setup is pretty easy.

Technical support has always been great for us, as strategic partners. 

There could be more scalability.

Microsoft should offer additional features for visualization and have additional features for slicing and dicing that data. Those would be good to have.

We've been using the solution since Microsoft introduced the solution to the market.

The product is more or less stable. Power BI doesn't have any problem with the stability aspect.

The solution can scale. It meets our needs.

We are dedicated partners. We have a couple of Microsoft architects that are dedicated to us. We have fairly decent support. I don't have any problem with them. If you ask a commercial end-user what kind of Microsoft support they get, in that case, you might get a disappointing answer. For us, we are satisfied.

I work with a services company and we work with a lot of different customers. So depending on which customer, what is that ecosystem, we'll end up using a lot of different BI tools. That includes both licensed and open-sourced software as well. For example, we've used Tableau and Microsoft Power BI.

I am personally not involved in the implementation process, however, my understanding is it's not that difficult to set up.

I don't oversee day-to-day operations. I just have a team that does that for me.

I cannot speak to the exact pricing. Sometimes we, for example, resell some licenses. We are strategic partners with Microsoft. It entirely depends on how the contract with the customers is. Sometimes the customer procures all the licenses and gives them to us and sometimes we resell the licenses. It completely varies from customer to customer.

We have a strategic partnership with Microsoft and a lot of our customers also are Microsoft shops.

We use both cloud and on-prem deployments. It's a mixed kind of a situation, depending on the customer scenario and situation. We have some implementations that are on the cloud and there are some older installations, legacy installations, which are on-prem. That is also giving us an opportunity to move them to the cloud. Most of our customers are looking to move to the cloud slowly and gradually. I anticipate that we will be seeing more cloud-based installations going forward.

There are one-off scenarios where the customer has an interesting mix of cloud platforms. They might have an IoT platform that is deployed on AWS, and that data is coming to the data lake and being visualized using Power BI, however, not necessarily on Azure.

I would rate the solution at a nine out of ten. 

Currently, it is used in our financial reporting and financial consideration reports.

It is stable.

It has good functionality and is fully integrated with Microsoft products. If you have already a direct connection or direct integration with Microsoft products, it is very good actually. In some cases, we just developed our BI dashboard and sent it to PowerPoint, for example. It'll be published as the power BI format, which is very good as a feature, to have that capability to just easily populate everything in PowerPoint.

Like all Microsoft products, it is very easy to set up initially.

It's pretty user-friendly.

The product can scale.

Our main concern with Power BI is it doesn't have a connection with the finance application. Power BI is used to present some financial data. However, if there is no direct connection or a ready API to be connected either to Oracle ERP or SAP or a different ERP, it won't be very useful. We need more integration capabilities. 

We've been using the solution for five years. 

The stability is good. There are no bugs or glitches. It doesn't crash or freeze. It's reliable. 

The scalability has been great. If a company needs to expand it, it can.

In my organization, there are about 10 to 20 users. The majority have shifted to Qlick.

I haven't contacted technical support in the past. The product has been so stable we haven't needed assistance. 

We have multiple BI tools. We previously worked with Oracle BI. Our expectations were not met, and therefore we moved over to Microsoft BI.

In my sector, currently, we are using Qlik Sense. We started using it one year ago.

We are shifting from Microsoft to Qlik due to the fact that we have Oracle ERP as a back end. We are trying to find a technology or BI, which already has a direct connection with this ERP. We went into Qlik Sense for that reason.

The initial setup is straightforward, actually. It is like any other Microsoft product. All of Microsoft's products are straightforward. It isn't complicated. This is one of the main benefits.

I'm not sure how long the deployment process was. I can't speak to how big the technical team was that handled the rollout.

We pay an annual licensing fee. 

I would recommend the solution if they already have a Microsoft ERP system. If they have already Microsoft and they have already their financial system in place and if they don't have data movement, Power BI will be very powerful. If a company has different financial systems, they have to track all these data points first, build the business model and then import it to Power BI. 

I'd rate the solution at an eight out of ten.

Microsoft BI can be useful for several scenarios, depending on your end audience, or what they're looking for. Depending on your creativity, imagination, and what the tool allows you to build, you can create a lot of cool things with it. You can build a lot of very elaborate and dynamic reports for example. The most important thing to consider is to understand what your audience is looking for. The development side of the tool is not the problem.

The usability of the tool is very simple. If you know the basics, it's fine. Even if you don't have the basics, there is a lot of self-service documentation available which helps to guide the user to start to use the tool, and how to navigate through it. 

There was also a new feature added last month to help new users practice using the system by providing an example data set to experiment with. Power BI server can be run on-premise so that your reports are available locally. Or you can have a premium version, including all your reports on the Cloud. It can be determined by the number of refreshes required from the reports or can depend on the volume of users that are consuming the reports.

The tool is very flexible so it allows for creativity. Power BI allows you to incorporate Microsoft Visio diagrams and other graphics from Microsoft tools. You can also integrate third-party visual graphics created from other tools, such as R or Python. It is useful to be able to obtain additional charts or different types of graphics developed by a third-party tool. This gives you more options for your end solutions. However, for some third-party tools and graphics such as Zoom charts, you have to pay for those separately. This is useful if you really wish to mesmerize your audience with dynamic, interactive visuals.

Alternatively, if you just want to use what is available to you, and with a little bit of UX/UI knowledge and creativity, you can build really cool stuff with it. For example, you can have dynamic dashboards on a screen that is connected in real-time. Users can interact directly with the data, so when they click the mouse, they can see the data changing. There's a lot of things that you can do with it. Let's say you develop a report, to put on a big touchable screen. Let's say the CEO is presenting to someone, and he's on a big screen. As soon as he touches a dialogue or a graphic on the screen, all the data changes. 

As an example, in CNN news, or any news, where they are presenting, and there are some dashboards and reports, journalist clicks on the screen, and everything changes instantly. That's what Power BI can do. If you have touch screens Power BI allows you to interact with your data.

I think that the product would benefit by increasing the range of visuals and graphics readily available, as opposed to using a third party included as part of the product. One way they could do that is for Microsoft to buy some of those third party companies, as they are specialists in visual creation, and they are making money from that. However, I understand that perhaps Microsoft maybe doesn't want to invest in that side of the business. Perhaps it is a financial decision. I would say that if we can have those additional visuals built into the product, it will be great. Alternatively, in the future, there should be an additional tool there that allows you to create your own visuals. That will give users more flexibility. 

It would also be useful for users with little experience in coding, or other Microsoft tools such as Excel. For example, let's say, you are a random user, and you're just looking at the computer for the first time. You open Power BI, but you know you can go to an Excel file and connect to that Excel file from Power BI. This is very simple and intuitive. So, once you have connected to the data, you can see your fields on the right-hand side, and all you need to do then is to drag and drop the fields you need. You can then select a relevant visual or graphic, and put the information alongside that visual, and then you have the visual and the data created as one item. This is very useful and dynamic. This would also have the other huge advantage, in that it would be a cheaper solution to use. I would like the ability to reuse connections. 

For example, if I created a connection to an SQL server, and I published my report using that connection, and then shared my report, it would be useful to be able to reuse the existing connection to the SQL server. In this way, I can reuse the existing dataset to create another report. I believe this is already the subject of a support ticket. Say I then wanted to reuse another connection from a different connection, say Oracle, to use in the same report, I could use the connections to those two sources and build the report. If I already have the sources online, and available for me, it would make sense that I could reuse them. At the moment, you can only reuse one data source. You cannot reuse more than one data source, at least if the data sources are online. One workaround would be to access each data source in turn, to obtain the data for the report. However, from October 2020, when using Excel driven reports, it is possible to reuse data flows or reuse the data component, from Power BI in Excel. So Microsoft has already implemented it for Excel, but it is still in the preview features. That will help a lot in financial areas. This could also impact company sales forecasts and sales.

I have 10 years of experience using BI tools, like Tableau, Power BI, QuickView, and MicroStrategy. I have a background in technical architecture but my main expertise is in BI tools. I use Power BI. It's a business intelligence tool that helps you develop and create reports that you can connect to various data sources. Then you can slice and dice, and build what you want to build from there.

Microsoft BI is stable.

The product is scalable, and new updates come out every month.

Microsoft Technical Support is very good. If I need their assistance, they will liaise with me. They are very flexible, useful, and very friendly. They are very open to helping you out. So depending on how you escalate your call, and say it's a high-priority issue they contact you very fast. They have support lines globally. So if I'm in the Czech Republic, I may be contacted by someone from Romania, or from India, or another zone. It's fine, if, for example, I'm not English, and I need to speak to someone who speaks Spanish, they put me in touch with someone who speaks Spanish. There is a lot of available support for Power BI, and they have their own Power BI page called Power BI Support. Power BI issues are registered on that page. Support usually fixes the issues within the given timeframe. The other good part about Power BI is the huge Microsoft community that it is there. So you can raise tickets and use the community which is on the same page. Sometimes the community helps you find your solution. So, it provides two ways to access support solutions.

It's easy to install which helps new users to the product. The installation process is easy. You can install it from the Microsoft store, or you can go directly to the Microsoft portal, and download the version that you require. It keeps historical versions available in case you need to test a different version. The advantage of the Microsoft store is that as soon as you install it from there, it always keeps you updated with the latest version. Also from a Power BI service point of view, you have several capabilities. The learning curve comes in when researching the different features, and what is new in the product, as well as what is going to be provided in future versions. The advantage of Power BI is that every month you have something new provided with the update. For example, you may have a new connection, additional visuals, or use new narratives.

We have 8,000 Power Bi licenses in our organization, so it is widely used. Setup is easy, and the cost is economical. You do sometimes need to pay additional costs for third party products which "plug-in" to Microsoft BI.

I would give Microsoft BI a 10 out of 10.

I use the platform primarily to create visualizations and reports from data to gain insights. It is utilized for operational, decision-making, and managerial reports.

The product's most valuable features are DAX functions for formulas and calculations.

I would suggest improvements in visualization standards, particularly in customization and appearance, to match tools like Tableau.

I have been working with Microsoft Power BI for two years.

I rate the platform stability a seven and a half or eight out of ten. 

The product is suitable for medium-sized companies with straightforward requirements. It can handle thousands of users, but its effectiveness depends on the data volume and reporting needs.

I rate the scalability an eight. 

The technical support team's response quality can vary based on the engineer's expertise and availability.

Power BI is more cost-effective, whereas Tableau provides more advanced features and higher-quality visualizations. For critical business needs and high data volumes, Tableau might be more suitable. 

The initial setup process is simple. 

I have worked with both the cloud version and the desktop model. Each has its advantages depending on the need for high-quality visualizations or the volume of data.

I rate the product pricing a ten. 

The solution supports integration from various applications well enough to meet most business requirements. 

I rate it a nine out of ten. 

We use Microsoft Power BI to manage and visualize the control of permits to work for service companies in industrial plants in Mexico. The control of permits is crucial because all service companies must be registered with a special number by the government, and all personnel must be certified for the specific work they will perform inside the plant. For example, if installing cameras at a high level, you need a permit for that specific condition, which has specific rules to comply with to carry out the job. In Power BI, we can visualize the number of permits, open permits, closed permits, refused permits, and all types of permits we have. This allows us to manage all permits for people working on various projects inside the industrial site.

The most valuable aspect of Microsoft Power BI in my field is the insights it provides from analyzing data. Sometimes, these insights go beyond what traditional analysis can reveal due to the large volume of data involved. In terms of improving our data analysis process, it starts with identifying data sources, followed by cleaning and filtering out irrelevant data. Then, we categorize and structure the data to achieve the best visualization and insights.

Regarding Power BI's integration with other tools, although we haven't implemented it ourselves, it's known that Power BI can integrate with systems like SAP or ERP software, which could enhance our analytics capabilities if needed.

I believe Power BI could improve by making data tables and databases easier to handle, especially for non-programmers who may not be familiar with languages like Python. Simplifying these aspects would enhance the usability and accessibility of Power BI for a broader range of users.

I have been using Power BI for the last six months.

In terms of stability, it's been reliable. We haven't encountered any bugs or crashes.

We've definitely seen a return on investment. We calculated the benefits and ROI for our solution.

Regarding cost, the initial investment wasn't too high, but ongoing licensing could add up.

Overall, I'd rate Power BI as an eight out of ten. It's been quite effective for us.

We have a lot of data, which we process and analyze using Python. Once the data is processed, we feed it into Power BI. In Power BI, we build dashboards and visualizations. Our team or customers can then view these dashboards.

Data visualization is crucial because while some people understand data, many find raw numbers or text difficult to interpret. Visualization makes patterns and insights clearer and easier to understand. Tools like Microsoft Power BI and Tableau are excellent for creating these visualizations, helping users grasp better and analyze large datasets.

For example, the variety of chart types available in Power BI is somewhat limited. While you can choose from various charts like dial gauges, bar charts, and line charts, there aren't as many diverse options as you might need. Sometimes, you might look for additional chart types and find that they're not available for download from the Internet.

Another area for improvement is data refresh functionality. Even with a premium license, the refresh rate is limited to every 30 minutes. This can be restrictive if you need more frequent updates, such as every 10 or 15 minutes, or at specific times, like every Monday at 4:25 PM. The current options are typically every hour, every 30 minutes, or daily. This limitation can lead to inefficient resource use if your data only needs to be refreshed at specific times.

I have been using Microsoft Power BI for four years.

Initially, Microsoft Power BI can be quite complex. The Microsoft website does not always provide clear guidance, so you might need to watch numerous YouTube tutorials. The initial setup can be challenging, but using Power BI becomes much easier once you become familiar with the process.

Once you use Power BI, you must install or subscribe to the software and spend time exploring and working with your data. Becoming fully proficient and deploying your solutions effectively may take a few months.

ROI is really great.

Power BI pricing is generally considered more affordable than Tableau. There is a free version available for Power BI, and the Pro version costs around $20 per user per month. In contrast, Tableau's pricing can be higher, with a Creator license costing around $70 per user per month.

Compared to Tableau, Power BI is considered more affordable. While Tableau is often seen as more versatile and professional, making it suitable for advanced and complex data visualization needs, Power BI is a more accessible option for beginners or organizations starting with data visualization.

Microsoft Power BI is a user-friendly tool for creating dashboards and visualizations. It allows you to easily import data from Microsoft Excel or CSV files, which are common data storage formats. Once your data is imported into Power BI, you can create a variety of visualizations, including line charts, bar charts, and gauges, to present it effectively.

Many people turn to resources like Google searches and YouTube tutorials to learn how to use Power BI. Microsoft also offers extensive learning materials.

Power BI has some AI capabilities, but it's primarily a tool for data visualization. For more advanced AI and machine learning tasks, such as those involving neural networks or complex algorithms, many data scientists prefer to use Python and integrate their results into Power BI for visualization.

Overall, I rate the solution a seven out of ten.

We use the tool for data analysis and reporting through dashboarding, identifying trends, and mapping.

The product is intuitive and user-friendly. It could be rolled out to anyone across the business. DAX is a good feature. The real-time dashboard updates are good. The ease of integration is good. We connect it to different databases. The clients we work with work on different databases. It is easy to manage and share Power BI reports across different teams and departments.

The solution struggles with large amounts of data. It has some limitations. Sometimes, we don't know if we have the full picture.

I have been using the solution for four years.

I rate the tool’s stability a ten out of ten. I haven't come across any issues.

I rate the tool’s scalability an eight out of ten.

The deployment is not difficult. It is relatively easy to maintain the product. For our needs, we need one person to maintain the tool.

I have used MicroStrategy. Power BI is more user-friendly. When we roll it across the business, it's easier for the users to use. MicroStrategy can handle large amounts of data.

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

It’s not just a specific tool I use when providing solutions. In these scenarios, clients often have a significant Microsoft presence with servers for data collection, whether it's in a data lake, data warehouse, or a data lake house. Their users typically require reporting, dashboards, or ad-hoc queries based on their specific business needs. However, most vendors tend to offer inflexible solutions, focusing on predefined reports.

Power BI stands out because it provides considerable flexibility in creating reports, dashboards, and various types of analytics to meet those dynamic requirements. It is lightweight and easy to use with good support.       

Microsoft BI typically connects to a database, often SQL Server, but it's also capable of connecting to multiple databases, pulling data from them, and allowing for data consolidation. You can then aggregate and generate dashboards and reports from this combined data. Personally, I wouldn't claim to have the expertise to suggest significant changes or additional features, as it functions quite well as is.

I have been using this solution for the past five years. 

It is a stable solution. 

It's a cloud-based platform, and it scales seamlessly based on your usage, which is one of the key advantages of cloud services. You pay according to your usage, without worrying about licenses or ownership. However, there are some limitations to consider. While it's a front-end tool for visualization and analytics, it lacks extensive customization options. If you require complex reports or queries, Microsoft offers support to help you achieve those goals. In my experience over the past five years, I haven't encountered any use case that couldn't be addressed with Power BI. On the contrary, I faced performance issues with other tools like Spotfire, which prompted us to explore different solutions. The effectiveness of Power BI also depends on factors like architecture, deployment, and network quality. If network configurations aren't optimized, it can lead to slow data transfer. However, being a cloud-based solution, the cloud infrastructure often manages these issues. Nevertheless, if you want the best performance, you might need to invest in improving your network infrastructure.

Positive

I'm not very familiar with the licensing aspect, as it operates in the cloud as a SaaS (Software as a Service) model. Essentially, you pay based on cloud cost models, which might include hourly rates or similar billing structures introduced by Microsoft. Many organizations utilize it and pay for its services, somewhat like Office 365. It's a cloud-based platform that provides the necessary services, including support, for development, and you pay accordingly for the usage.

 would recommend the solution, rating it eight out of ten. There’s no such thing as an ideal product. In my perspective, perfection remains an unattainable goal. However, I can't rate it lower than eight because Microsoft actively invests in BI's development and expansion. They have a roadmap and allocate resources to it, which is evident in the growing user base. This continuous growth adds value to the product and benefits its users.