The interactive reports, DirectQuery and integration with the other Microsoft services are valuable features.
Senior Software Engineer - Business Intelligence at a tech consulting company with 51-200 employees
The interactive reports, DirectQuery and integration with the other Microsoft services are valuable features.
What is most valuable?
What needs improvement?
There needs to be support for more data sources in DirectQuery.
DirectQuery is a method of connecting your data directly, i.e. any changes in data source will reflect in report immediately. (This is very great feature if you are doing live analysis of your data). As of now there are limited number of Data Sources such as SQL, SQL Azure, which are supported by Power BI with DirectQuery. Although Microsoft keeps working on adding different data sources in DirectQuery (currently only six data sources in this method and three more in Preview), that's why I feel that still DirectQuery (method of connecting your data) has more room for improvement because there are many other data sources that are commonly used by different organization like (MySQL, Access, etc.)
For how long have I used the solution?
I have used this solution for two years.
What do I think about the stability of the solution?
In the beginning, we did encounter some stability issues; now, Microsoft is doing great things to make this product more stable and enhanced.
Buyer's Guide
Microsoft Power BI
November 2024
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
815,854 professionals have used our research since 2012.
Which solution did I use previously and why did I switch?
We were using SQL Server Reporting Services (SSRS reports), now we are moving towards Power BI due to its Publish on web part, as well as the interactive cross-filtering throughout all the visuals (i.e., if you need).
How was the initial setup?
The setup is easy. It is very easy to use. If you are an Excel and SQL user, then it is very easy to get a grip on this product.
Which other solutions did I evaluate?
We tried Tableau. Although Tableau itself is a great product, we chose Power BI due to its pricing and Microsoft's focus to make it a better product.
Disclosure: My company has a business relationship with this vendor other than being a customer: We are Microsoft Gold Partners.
Technical coordinator at a university with 201-500 employees
Reliable, problem-free, and easy to set up
Pros and Cons
- "We have found the product very stable and reliable."
- "The reporting needs to be improved."
What is our primary use case?
We are using it, for instance, to figure out some indicators in regards to our students including the number of students, which are graduating, et cetera.
What is most valuable?
The initial setup was pretty simple.
The solution runs without issues. It's been problem-free.
We have found the product very stable and reliable.
The scalability seems to be fine for us.
What needs improvement?
We'd like to have the ability to relate different reports by common factors from the user side, including relating different reports directly instead of fetching the data to enter into an external tool like Excel or something like that. The reporting needs to be improved.
For how long have I used the solution?
I've used the solution for about three to six months or so.
What do I think about the stability of the solution?
The stability has been good. There aren't bugs or glitches really. It doesn't crash or freeze. It's pretty reliable.
What do I think about the scalability of the solution?
For our use case, the solution offers reasonable scalability. We haven't run into issues.
We have 40 to 50 people using the product right now. They are across different roles.
I'm not sure if we have a plan to increase usage at this time. We likely will not.
How are customer service and support?
I haven't had a need to reach out to technical support as it's largely been problem-free. I can't speak to how they would be for support. I do not know if they are helpful or responsive.
How was the initial setup?
We found the initial implementation process to be straightforward and simple. It's not overly complex or difficult.
I cannot recall the exact amount of time it actually took to deploy the product.
What other advice do I have?
I'm an end-user. However, I'm not sure which exact version of the solution we're using.
I would rate the solution at an eight out of ten. We've largely been very satisfied with its capabilities.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Microsoft Power BI
November 2024
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
815,854 professionals have used our research since 2012.
Associate Data Analyst at a financial services firm with 10,001+ employees
Provides infinite possibilities for visualizations and excellent integration
Pros and Cons
- "Previously we used Excel, which took a long time - two or three weeks - to bring the data into a uniform format, whereas BI can do the same job in a day."
- "I would like Microsoft to include some inbuilt machine learning so that it becomes point-and-click, rather than us developing models out of API and BI connecting to that and getting the results. That process gets in the way of continuity."
What is our primary use case?
I work in fraud analytics in the insurance industry and use Power BI for broader and high-level reports. We also do some fraud detection, and our output is sent to a Power BI dashboard for various clients to see. It's basically our visualization tool organization-wide.
What is most valuable?
The most valuable feature is the infinite possibilities when it comes to visualizations. If a particular visualization is not available as a default or in the market, you can just load in a Python nr script and get a visualization from that. It's very flexible in that respect and opens up a plethora of opportunities. The huge number of connectors that are available is also a big advantage - BI can connect to various things, even competitors like Google's Data Studio, and it is even able to connect to various Google data sources and be a powerful alternative to Data Studio. It's also a data modeling tool, so it keeps everything within the app, which is really convenient, allowing the pipeline to complete itself in a more fluid way.
What needs improvement?
In the next release, I would like Microsoft to include some inbuilt machine learning so that it becomes point-and-click, rather than us developing models out of API and BI connecting to that and getting the results. That process gets in the way of continuity.
For how long have I used the solution?
I've been using this solution for two years.
What do I think about the stability of the solution?
Power BI's stability has improved in the last few years and now seems pretty good, especially with R.
What do I think about the scalability of the solution?
I don't know if BI is directly scalable, but we used a lot of aggregated marks in order to make sure it is able to work with a huge number of roles in the data set. Microsoft demonstrated that they were able to achieve up to one trillion rows, and we haven't got there, but we did get close.
Which solution did I use previously and why did I switch?
Previously we used Excel, which took a long time - two or three weeks - to bring the data into a uniform format, whereas BI can do the same job in a day.
What other advice do I have?
If you're on Azure, Power BI is tightly integrated with many of the products. And even if you have a non-Azure solution, the family of connectors for data sources is wide, so you can fit it in many places. I would rate BI as nine out of ten.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
MIS Specialist at a agriculture with 201-500 employees
It's easy to conduct analysis but needs more work to make it stable
Pros and Cons
- "Microsoft BI is better than most solutions we have. It's pretty easy to conduct analysis with it."
- "Microsoft needs to do some more research and development to make it more stable."
What is our primary use case?
In our sector, we're dealing with lots of FinDocs and routine FinDoc activities. So all these things are managed locally, with data coming from some secondary source. By that, I mean our in-house technicians provide a data service that is locally developed on our end, and we analyze data in Microsoft Power BI. We have about 10 to 12 users working with it.
What is most valuable?
Microsoft BI is better than most solutions we have. It's pretty easy to conduct analysis with it.
What needs improvement?
Microsoft needs to do some more research and development to make it more stable.
For how long have I used the solution?
We've been using Microsoft BI for about six months.
What do I think about the scalability of the solution?
I think Microsoft BI is scalable.
How are customer service and support?
We have some technical partners from Microsoft, so we contact them for any issues.
How was the initial setup?
Installing Microsoft BI is fast and easy. We just downloaded it from Microsoft. That's it. It only takes about half an hour. It takes a little longer for the overall deployment, depending on the data volume. If we're getting the data from a secondary source, it depends upon both the source and volume. The greater the volume, the greater the time. Usually, we can manage to get it done in one or two hours plus the testing. It takes around four people to deploy and manage the solution.
What's my experience with pricing, setup cost, and licensing?
We haven't thought much about licensing because we're still dealing with some administrative hang-ups. Once all these things are resolved, then we go for the license. It is in process.
What other advice do I have?
I rate Microsoft BI six out of 10. I would recommend it.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Summer Intern at a financial services firm with 10,001+ employees
Good visualization capabilities, a lot of online content, but not easy to define a relationship and has a bit of a learning curve
Pros and Cons
- "Its visualization capabilities are pretty good. It is very easy to use. You can easily make your dashboard."
- "Defining a relationship was very confusing. There were circular directions for which I had to do a lot of adjustments in the data. They can do something to make it easier."
What is our primary use case?
I used it to build a simple dashboard. What I did was very simple. I used it to load different datasets. I defined relationships between them and played around with the data by using visuals.
I must have downloaded the version that was really available at that time.
How has it helped my organization?
I had to build a simple dashboard in which I had to combine two or three different datasets. They were large enough, so it wasn't possible to work on them easily in Excel. In Power BI, I used the relationship feature, and I was able to store the data in such a way that it does not occupy a lot of space. I could then send the file over email.
What is most valuable?
Its visualization capabilities are pretty good. It is very easy to use. You can easily make your dashboard.
There is a lot of self-help content available from a lot of different platforms, such as YouTube. So, whenever I faced an issue, it was not difficult. I could always find a solution to the issue I was facing.
What needs improvement?
Defining a relationship was very confusing. There were circular directions for which I had to do a lot of adjustments in the data. They can do something to make it easier.
For how long have I used the solution?
I worked on it this summer. I just used it for a month or two.
What other advice do I have?
Defining Relationships can be confusing when you are working with a complex data model. It can result in circular relationship referencing and the interface does not help solve it, or even understand it, in any way. It takes time to figure out a different way to structure the data model and Power BI offers no guidance on that. Online help is limited.
There is a lot of content available online. When I started out, the way I was defining the relationship between the data and the way my model was structured was not very efficient. I spent a lot of time in making it more efficient. So, I would advise others to do enough research. I was learning on the go. If you spend about six or seven hours learning it, it would be much better. Even though it is marketed as something that is easily usable and anyone can come and start using it, there is a bit of a learning curve.
I was very easily able to load the data and conduct an as-is analysis of what is happening, but if I want to do a deeper analysis of the data and break down a variable into different components, I don't know if it is possible in Power BI. I tried to do it a little bit, but it was not easy. So, it is good when you have the data, and you just want to present it and look at it in different ways, but if you want to analyze the data and break down the numbers and play around with the data, I don't know if it is possible in Power BI.
I would rate Power BI a seven out of 10.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PMO at a consultancy with 10,001+ employees
Highly performance, easy to use, but needs more data flexibility
Pros and Cons
- "What I have found valuable about Microsoft BI is its performance and ease of use. The interface is very simple and it is accessible to everyone. If someone is new to this type of solution it is straightforward to understand."
- "In the future, Microsoft BI can be better by increasing user-friendliness"
What is our primary use case?
I use Microsoft BI for the reports and our displaying the data in different ways. As a project manager, I need to follow the budget and receive confirmation about our projects. We have an SAP database and we follow and check all the budget data of the project including data usage.
What is most valuable?
What I have found valuable about Microsoft BI is its performance and ease of use. The interface is very simple and it is accessible to everyone. If someone is new to this type of solution it is straightforward to understand.
What needs improvement?
The solution could improve by having more options to manipulate the views of the data on the dashboards. I sometimes need to make them myself but there should be more customizable with drag-and-drop elements and filters on that data differently than it was designed. There are filters in the design stage but there are times you need something else other than how it was designed. For example, if you did not have some of the information at the time of the design. Having the ability to design, or request the data from the database as an end-user is very important. It would be beneficial to have more autonomy on the design of the requested data. You are not able to change the fields or the request data because it was done in the backend and you are not able to see how that request happened. Sometimes you need to make your own requests or have different requests regarding the data. We do not have access because we are not administrators.
In the future, Microsoft BI can be better by increasing user-friendliness.
For how long have I used the solution?
I have been using this solution for approximately three years.
What do I think about the stability of the solution?
The solution is stable.
What do I think about the scalability of the solution?
I have found it to be scalable.
We have approximately 1,000 people using the solution in my organization.
Which solution did I use previously and why did I switch?
I have previously used QlikView and Qlik Sense.
What other advice do I have?
I would recommend this solution to others.
I rate Microsoft BI a seven out of ten.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
BI Solution Engineer at DataSelf
Easy to use for buildings charts and graphs and doing calculations
Pros and Cons
- "It is a little easier at buildings charts and graphs than Tableau."
- "It has limited performance capabilities in terms of connecting to large transactional databases, but it is fine for simple and quick queries from Excel spreadsheets or one table. The premium level is going to be more applicable for the higher transaction-level databases."
What is our primary use case?
I've been a consultant, so I've built some reports for some clients. I use and prefer its desktop version.
What is most valuable?
It is a little easier at buildings charts and graphs than Tableau.
What needs improvement?
At the enterprise level, it is a little expensive. To get the full capacity of integrations, you need to go premium.
It has limited performance capabilities in terms of connecting to large transactional databases, but it is fine for simple and quick queries from Excel spreadsheets or one table. The premium level is going to be more applicable for the higher transaction-level databases.
For how long have I used the solution?
I've been in the Business Intelligence Industry for about seven years. I use this product off and on.
What do I think about the scalability of the solution?
It is complex to scale. There are just too many things you have to put in place. You got to have the gateways, and you got to have the premium service. There are a lot of components that get involved. It is not very straightforward.
We sell our own BI tool. So, we have hundreds of clients. They are mid-sized organizations. We're building out our Power BI stack because people do like it, but right now, we have most of our stuff in Tableau.
Which solution did I use previously and why did I switch?
I also use Tableau. They're very comparable products. I worked for different companies that built their own proprietary stuff, and mainly for visualization, Tableau and Power BI were the connectors to go to. So, there wasn't a switch.
I really like Tableau's web version over Power BI's web version. It is just easier to drag and drop things and blend data on the backend. It has a little simpler process in that regard. I don't like the charting in Tableau. Its charting is a little more complex than Power BI's charting.
Calculations are a little harder in Tableau. They can be a little more complex in Tableau as compared to Power BI. Tableau is a little more detailed in terms of creating calculations. You can't just add two columns together. Tableau should have the ability to add or subtract columns. They should make it like a wizard.
How was the initial setup?
The simple stuff is easy. When you want to get into the calculations and building DAX-type formulas, I don't think DAX is that great. I find Tableau's coding a little easier.
What's my experience with pricing, setup cost, and licensing?
Its pricing is reasonable for the desktop stuff, but for enterprise-level, it is a little expensive.
What other advice do I have?
I would advise others to just do their research and figure out what they want to do with it so that they know if it is going to be hard or easy.
I would rate Microsoft BI an eight out of 10.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer:
Head of Digitalization at a mining and metals company with 5,001-10,000 employees
Seamlessly integrates with Microsoft products, but can be made simpler to operate
Pros and Cons
- "Its seamless integration with Microsoft products, such as Microsoft SQL Server or Microsoft Excel, is the most valuable."
- "They can provide a user-friendly and easy way to use this tool for people who don't know about programming or technical things. It will be quite good if they can improve the look and feel and make it simpler to operate. They can make it easier to create some of the reports. They can also include predefined templates that you can directly use."
What is our primary use case?
It is mostly used for monthly cost reports for our department. We are also using it as a dashboard for giving some overview for management purposes. We are using the latest version.
What is most valuable?
Its seamless integration with Microsoft products, such as Microsoft SQL Server or Microsoft Excel, is the most valuable.
What needs improvement?
They can provide a user-friendly and easy way to use this tool for people who don't know about programming or technical things. It will be quite good if they can improve the look and feel and make it simpler to operate.
They can make it easier to create some of the reports. They can also include predefined templates that you can directly use.
For how long have I used the solution?
I have been using Microsoft BI for almost two and a half years.
What do I think about the stability of the solution?
Stability is quite good as long as you have proper sizing from the beginnings. If you do the right sizing keeping in mind the current usage as well as future growth, it is good.
What do I think about the scalability of the solution?
It is scalable. We have around 65 seniors managers who use it on a weekly or monthly basis. Some reports are done weekly and some monthly.
How are customer service and technical support?
I have not contacted them so far. I am from the user side. We contact our centralized IT department for any issues. If they have a technical issue that requires further escalation, they will directly contact Microsoft technical support.
How was the initial setup?
The initial setup is quite simple, but for the product use, you need to have people who have got experience of at least three to six months in using these applications. It took us two months to deploy across the company.
What about the implementation team?
We have a core team that gets training from a Microsoft partner. We then deploy it ourselves. After six months of using this solution, some of the key users get advanced training.
We also maintain it ourselves. We have around ten people for its maintenance.
What's my experience with pricing, setup cost, and licensing?
It is somewhere in the middle in terms of price. Licensing is quite clear.
Which other solutions did I evaluate?
We reviewed some other intelligence tools, and we just used them for trials.
What other advice do I have?
I would recommend this solution, especially for the companies that mostly use Microsoft products and ecosystem. I would rate Microsoft BI a seven out of ten.
Which deployment model are you using for this solution?
Private Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros
sharing their opinions.
Updated: November 2024
Popular Comparisons
Splunk Enterprise Security
Databricks
SQL Server
Amazon QuickSight
Teradata
IBM Cognos
Rapid7 InsightVM
SAP Analytics Cloud
Qlik Sense
SAP BusinessObjects Business Intelligence Platform
Oracle OBIEE
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- BI Reports for business users - which BI solutions should we choose?
- Business users moving from Tableau to MS Report builder
- Is Power BI a complete platform or only a visualization tool?
- What are the key advantages of OBIEE compared to Microsoft BI?
- What Is The Biggest Difference Between Microsoft BI and Oracle OBIEE?
- Is Microsoft Power BI good for an ETL process?
- How would you decide between Microsoft Power BI and TIBCO Spotfire?
- Is it easy to extract data from Oracle Fusion into Power BI?
- PowerBI or SyncFusion - which is better?
- What challenges to expect when migrating multiple dashboards from TIBCO Spotfire to Microsoft Power BI?