Microsoft Power BI Reviews

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.

My company, we work as consultants. We help set up the environment for our customers. We do the initial setup for the customers so that they can use it. 

To a certain extent, we also set up dashboards and workplaces within Power BI for customers and run automation.

Our customers are mostly in security, finance, and some marketing companies.

The dashboards are valuable. We use them to help customers who are scattered across multiple countries. We can scope the access and information so that only relevant parties have visibility to what is relevant to their environment.

I haven't used real-time data processing much. It's more about the dashboards, where we play around. We work on Microsoft 365 and Azure and populate the dashboards with that information. Then, the dashboards are published to the end users so they can view relevant information.

The AI support is really good. We have plans to use the AI mechanisms and algorithms that Power BI uses to publish more easy-to-understand reports for our customers. We don't have to start things from scratch when we have metadata via AI. It integrates with the existing Power BI system and pulls up the data. It feels like they are being more open so that the data can be easily readable, and then using AI, it can be published in a better way.

The only issue is with permissions. Sometimes, despite granting granular permissions, dashboards are visible to people who shouldn't have access. It's difficult to understand why the permissions slip out.

Sometimes dashboards are visible to stakeholders even though they should not have permission. It's a bit difficult to understand why the permissions slip out.

The dashboards lack a user-friendly appearance, and the permissions should be easier to understand. At this point, we have to go through a lot of details. It takes a lot of time to understand the permissions, so if there were better options available within the Power BI setup, it would be quite beneficial, especially for admins.

So, there should be a more user-friendly dashboard appearance and easier-to-understand permissions.

I have been working with Power BI for two years. 

It is quite stable. I would rate the stability a nine out of ten. I haven't heard any complaints from our customers. 

I would rate the scalability an eight out of ten. It still needs some more things within the system.

Our customers are mostly medium and enterprise businesses. 

The support has been good. It takes time for them to respond, but when they do, they are helpful. I would give it an eight.

Positive

The initial setup is easy. It's quite easy. Not that complicated. You just need the license, and then you're done.

I would rate my experience with the initial setup a nine out of ten, with ten being easy. 

It takes a couple of hours, four hours to eight hours. 

We are the integrators.

It did positively impact ROI. From a time perspective, at least four to six hours are saved because a lot of manual work is eliminated. Things are easily available, so people can do their work more efficiently.

When you have more number of users, like we have one customer with 200,000, it's a bit expensive. But I feel it's reasonable for small-scale customers.

I would recommend exploring it. A lot of features are available within Power BI. People complain that they want this or that, but everything is there. Explore it more, read through the documentation, and that would be helpful.

Overall, I would rate it a nine 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. 

I would describe myself as more of a casual user, only because I have so many other things that I have to get done. I wish I could be more of a user, but it's hard. Right now, I have two different main use cases. I use it for teaching. At another institution, I use it for demonstrating how easy it is to build dashboards. It was really to show to all my users the benefit of business analytics. I use it to demonstrate how easy it is to generate your own analytics versus having a department run reports for you then putting it in Excel and making graphs. 

I like the fact that Power BI lets me use Excel data. At least 90% of my state data is in Excel spreadsheets. Having the ability to just attach a spreadsheet as a data source is very, very important. It's also good for training and teaching. Sometimes you don't always have access to a live production database, so having a spreadsheet with sample data is always nice.

The Microsoft BI interface should be simpler and more user-friendly. I find it very difficult to move between their data sources and their analytics section. It's probably designed by data analysts that typically get the data from somewhere else. So, one person logs into Power BI, moves the data around and puts it in the proper form then somebody else goes in from the dashboard. What I'm finding more and more is that the person playing with the data is also going to be the person building the dashboard, so the interface needs to be more seamless and dumbed down for the average user. 

Tableau is much better at that, which is probably why it's more expensive. The days where one person works on the data and someone else does the analytics are coming to an end. In the past, larger organizations usually had a dedicated analytics team and a dedicated data team. Now we buy data as a service, so we got rid of our data team and we don't have analysts per se. Instead, we have smart users. So I think Microsoft BI needs to move on to the next iteration of truly user-friendly solutions.

I've been using Microsoft BI for about three years.

Microsoft BI has never crashed on me.

I honestly can't comment on how scalable Microsoft BI is because I've never taken it beyond training or simple use. But I would imagine, if it's on Azure, that it's scalable. I haven't had the pleasure of scaling it, so I don't know, but it doesn't strike me as a solution that would have problems with scalability.

I have not had to contact technical support, but I've actually downloaded and taken three Power BI courses for free and they're very good.

I was using Tableau but the licensing cost went up when Salesforce required them to raise the price. But if the price hadn't changed, I would've absolutely stuck with Tableau because I like it. I do not know about the cost of the licenses. We buy it from the state and when it went up, our CIO at the time said no more Tableau licenses. I had to scramble to find a replacement, and fortunately, I discovered that Power BI is included in Microsoft 365. However, I prefer Tableau's interface. Microsoft BI's user interface is convoluted in terms of how you attach a data source. You have a separate screen for defining your data and then you have to jump to a different screen to model the results. In other words, there are two separate interfaces for data and analytics. In Tableau, it's more seamless. 

Setup is very easy. You click on the icon, download the MSI, and it loads itself. It takes about a couple of hours to deploy overall.

I'd rate Microsoft BI as an eight out of 10. The biggest drawback is the user interface. From what I'm seeing, Windows 11 is going to have a more user-friendly interface. Even Microsoft Edge is adopting a more user-friendly interface. I'm hoping that Power BI follows this trend as well. 

My advice for anyone who is thinking about adopting Microsoft BI is to understand what you're trying to do with it. If you're trying to do analytics with it, then it depends on the kind of analytics. If you're want to do statistical analytics, it's not the tool for you. It's a tool that's better suited for visual analytics than it is for straight-up analytics. If you're dealing with patterns and data, it's great. If you're working with numbers and data, it's not so good. You're better off with a statistical package.

We use Microsoft Power BI for both data manipulation and visualization, with a strong emphasis on data-driven storytelling. It allows you to clean and transform data. You can connect to various data sources, such as Excel, SQL databases, and SharePoint files, and clean and prepare your data using Power Query. Additionally, you can write DAX to create powerful measures for diverse use cases. Power BI enables the creation of highly insightful dashboards to convey information.

The data manipulation and data cleaning tasks are handled in the backend by Power Query in Microsoft Power BI.

Integrating data from multiple sources in Microsoft Power BI is very easy. For example, you can connect to SharePoint, various SQL servers, and other platforms. Power BI also offers a range of connectors and libraries for integrating data from various sources, including databases, online services, and cloud-based platforms. It saves a lot of time by handling large datasets. It can process millions of rows of data and allows users to create visualizations and analyze trends quickly. Power BI is effective for various types of data analysis and can adapt to complex data needs.

Additional features can enhance Power BI's capabilities in predictive analysis. Currently, Microsoft Fabric is integrated with Power BI. As Copilot and further integrations continue to develop, they will enhance Power BI's functionality.

It offers a range of formatting options for reports and dashboards. For example, if you have multiple headers and change one header's color, all the subheadings can automatically adopt the same color. This feature allows for extensive customization and formatting, which is important because leaders often prefer color-coded information presented in a specific manner.

I have been using Microsoft Power BI for seven years.

I rate the solution’s stability a ten out of ten.

More than 400 people utilize it. It is suitable for small and medium businesses.

You can create dashboards using Power BI Desktop and share the Power BI Desktop file itself. However, for larger organizations, Power BI offers a web-based solution through Power BI Service, where you can publish reports and dashboards.

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

Microsoft offers excellent products, and its community provides many options and support. If users encounter specific issues, they can find solutions in various Microsoft communities.

I have experience with both Microsoft Power BI and Tableau. Working with Tableau posed multiple challenges, such as data integration and ETL, which can be quite complex. Additionally, Tableau's measures and visualizations can be somewhat intricate. However, the flexibility in Power BI is comparable to that of Tableau.

I used Tableau for about five years before switching to Power BI, so I have a total of around eleven years of experience with these tools. As an advanced Tableau user, Power BI is simpler in comparison. Additionally, Tableau requires a paid license, whereas Power BI does not require a purchase unless you deploy it.

The initial setup is simple. You can start in about twenty minutes. However, you'll need to thoroughly understand the application to gain deeper and more critical insights. While you can learn the basics within a few hours, mastering the more advanced features involves a steeper learning curve.

Compared to other solutions, it can be relatively expensive, while the cost can be more manageable for organizations, considering the scale and the benefits.

Power BI offers several built-in AI capabilities. For instance, it includes features for sentiment analysis, generating word clouds, pattern recognition, and trend analysis. While Power BI integrates well with various external data sources and services, including advanced AI models, many analytical functions are available directly within the Power BI suite.

Overall, I rate the solution a ten 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.

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.

Across retail, logistics, legal, finance, and more, I use Power BI to craft custom solutions. From analyzing sales to optimizing operations, Power BI helps me extract actionable insights for informed decision-making across diverse industries.

I'm working with a law firm that has hundreds of professionals working across various areas for different clients. They struggle to accurately track hours worked per client and compare profitability. With Power BI, I can integrate data from their ERP systems and create insightful reports. These reports not only show the hours worked per client but also compare profitability between clients and highlight KPIs. By providing clear and actionable insights, Power BI helps the firm make informed decisions quickly, leading to improved profitability and efficiency.

The most valuable feature of Power BI is its ability to provide customized visualizations and insights tailored to specific business needs. By offering a range of visualization options and customization capabilities, Power BI enables users to quickly analyze data and gain actionable insights. Depending on the preferences and requirements of the customer, different visualization styles can be utilized, from simple and standardized views to more colorful and dynamic charts and graphs.

Areas of Power BI that could be improved are the learning curve for developers who come from non-technical backgrounds. While Power BI is a powerful tool, mastering its development aspects, including coding and formulas, can be challenging for those without a technical background. Additionally, some users find the default visualizations in Power BI Desktop to be outdated and prefer more modern and customizable options. 

One additional feature I would like to see in Power BI is tighter integration with Power Apps. This would allow for easier development without extensive coding, making it more accessible for users who aren't familiar with technical aspects like JSON files or Visual Studio Code. Simplifying the development process would streamline workflow and enhance overall usability.

I have been working with Microsoft Power BI since 2016.

I would rate the stability of Power BI at around nine out of ten. It has been consistently reliable over the past year, and any bugs are quickly addressed by a supportive community.

Power BI is scalable, but its scalability depends on factors like the amount of data, infrastructure, and database type. For large BI data, other tools might be more suitable. However, Power BI offers great flexibility, and its scalability varies based on specific needs and circumstances.

The technical support for Power BI is generally good, but it can be limited in handling diverse customer needs. While Microsoft technicians are highly knowledgeable, they may provide standard solutions based on their expertise, which might not cover all possible scenarios. Finding solutions often requires additional research, practice, and exploration of community resources. Overall, I would rate the support at a nine out of ten.

Positive

Deploying Power BI isn't difficult, but it requires time and experience. With regular updates and new features from Microsoft, staying current and understanding changes can be a continuous learning process. While it is manageable with experience, teaching someone from scratch would require significant time and effort.

The price of Power BI is very good. It is reasonable.

Power BI has revolutionized our reporting and decision-making processes. Instead of spending hours manually working with static data in Excel, we now have dynamic information at our fingertips. With Power BI, we can quickly make queries, access answers, and generate reports in minutes. By efficiently extracting data from databases and creating visually appealing visuals, such as KPI dashboards, Power BI enables us to identify trends, compare data, and make informed decisions promptly. It streamlines the entire process, from data extraction to visualization, saving us time and providing valuable insights for effective decision-making.

My advice for someone looking to use Power BI would be to start with the Pro license, as it is usually sufficient for most users. If you are dealing with a large number of customers, consider consulting with a Microsoft partner to find the best licensing solution. Based on my experience, I would recommend Power BI to others. Overall, I would rate the product as a nine out of ten.