Our primary use cases for this product are monitoring and reporting. I have some dashboards for the sales department and a little bit for operations. I'm going to create a new dashboard for marketing.
Business Intelligence Developer at a manufacturing company with 51-200 employees
Great for monitoring and reporting
Pros and Cons
- "Premium features that used to cost $5,000 per company per month recently became a lot more accessible. Microsoft recently implemented a per user feature in Power BI Premium; it's $20 per month."
- "I would like to be able to use more predicting data science features without having to use R."
What is our primary use case?
What is most valuable?
What I like about Power BI compared to Tableau, for example, is that Tableau is mostly a visualization program, but Power BI is a more complete solution, because it has DAX, Power Query, and a presentation and graphic layer. So, I use it not only for reporting and graphic purposes on the frontend, but also for doing things like modeling. It is very flexible, a lot more flexible for than Tableau for what I need.
One of the things that I appreciate is that premium features that used to cost $5,000 per company per month recently became a lot more accessible. Microsoft recently implemented a per user feature in Power BI Premium; it's $20 per month. I'm investigating in that because I think the price is good.
What needs improvement?
I would like to be able to use more predicting data science features without having to use R. If I were able to do most of the data science that I normally do inside Power BI without using R, I would decrease my use of R and mostly use Power BI.
For how long have I used the solution?
I have been using Microsoft Power BI for four and a half to five years. I have been using it since they created in basically. I started using it when it was Power Pivot in Excel and as soon as they created Power BI, I started using it.
Buyer's Guide
Microsoft Power BI
May 2025

Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
857,162 professionals have used our research since 2012.
What's my experience with pricing, setup cost, and licensing?
I recommend easing into Microsoft Power BI gradually. I started by creating models and graphics in Excel first. Then, when I learned a little bit about modeling, I started moving to Power BI and working there.
So, I recommend starting with Excel and practicing there first. Power Pivot is the app that you can use in Excel for this kind of work. Before switching to Power BI, learn about data modeling and dashboarding in Power Pivot in Excel first.
Which other solutions did I evaluate?
Before switching to Microsoft Power BI, I evaluated Tableau. It's a lot cheaper to use Power BI. The cost per user in Power BI is around $10 per month, while the cost per user for Tableau is a lot more expensive. That was a deciding factor for me.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: My company does not have a business relationship with this vendor other than being a customer.

New Build Completion & Commissioning at a energy/utilities company with 1,001-5,000 employees
Powerful, user-friendly, and easy to set up
Pros and Cons
- "The product can go easily go and extract data and it can put it into any format."
- "I'm not overly technical, and so I can't really speak to any shortcomings from a technical standpoint."
What is our primary use case?
We primarily use the product for running the reports and all data extraction in our organization.
What is most valuable?
The solution is a wonderful tool overall.
Power BI is very powerful and very easy to use. Its user-friendliness is one of its most valuable aspects. It has a very nice user interface that makes everything easy to navigate.
The product can go easily go and extract data and it can put it into any format.
It's a very good data analytic tool.
The initial setup is pretty easy. It's pretty straightforward in general.
What needs improvement?
I can't say that anything glaring is missing from the offering at this time.
Microsoft is doing a lot of research on it and they're coming up with a lot of good release items.
I'm not overly technical, and so I can't really speak to any shortcomings from a technical standpoint.
I'd like to have more time with the solution to evaluate it to see if there's really anything missing. We don't really go in-depth with the product.
For how long have I used the solution?
I've been using the solution since about 2017. It's been a few years now.
What do I think about the stability of the solution?
The stability is very good. It's a Microsoft product and therefore they wouldn't put anything out that wasn't tested and worthy of release. There aren't bugs or glitches. It doesn't crash or freeze. It's quite reliable and offers good performance.
What do I think about the scalability of the solution?
While the scalability is there, the cost is what you have to factor in. It has to scale as if there's more data, it needs to meet that demand and be able to extract and analyze it.
How are customer service and technical support?
Technical support for the most part has been very good. They are helpful and responsive. We are satisfied with the level of support we receive. On a scale of one to 25, I would give it a mark of 20.
How was the initial setup?
We've found the initial setup to be pretty straightforward. It's not complex. A company shouldn't have too much trouble getting everything up and running.
What's my experience with pricing, setup cost, and licensing?
I'm not sure of the exact cost of the solution. It's not an aspect of the product I need to worry about.
I am aware that we currently have an enterprise license.
Which other solutions did I evaluate?
I personally haven't evaluated or compared any other solutions. I don't have any knowledge in terms of how it compares to other options.
What other advice do I have?
We are customers and end-users. We don't have a specific business relationship with Microsoft.
I would rate the solution eight out of ten overall. We've been pretty satisfied with the product.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Buyer's Guide
Microsoft Power BI
May 2025

Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
857,162 professionals have used our research since 2012.
Project Manager at a computer software company with 5,001-10,000 employees
User-friendly with a straightforward setup and good stability
Pros and Cons
- "The initial setup is pretty straightforward."
- "It seems that the solution could use more analytics to help users draw more contextual business insights. Right now, you need other solutions for that."
What is our primary use case?
We primarily use the solution to run our industry reports. We get the data from data warehouse we are creating. I use it to export the data.
We have been using Microsoft BI for one of the customers. That was completely in the customer environment. That's all. We did not have that solution for us in-house. However, we are working towards introducing it for our own purposes in the near future.
What is most valuable?
The product is very user-friendly.
The solution can be used with any BI tool you have.
The initial setup is pretty straightforward.
The solution has been very stable for our customers.
It appears the solution has the capability to scale, although we have yet to try to do so.
What needs improvement?
We have yet to implement the solution completely. We're still exploring features and capabilities. It's too early to discuss items that may be lacking.
It seems that the solution could use more analytics to help users draw more contextual business insights. Right now, you need other solutions for that.
For how long have I used the solution?
I've been using the solution for the past five years now. It's been a while.
What do I think about the stability of the solution?
The product has been quite stable so far. The performance is good. It's reliable. There aren't bugs or glitches. It doesn't crash or freeze.
What do I think about the scalability of the solution?
We have not attempted to scale the solution yet. We are in the initial stage of exploring different features on it. We believe it to be a scalable product, however, we have not attempted it ourselves yet. We might in the future.
We don't have any customers on the solution right now as we are just trying to figure things out.
How are customer service and technical support?
We haven't used technical support. I wouldn't be able to speak to how helpful or responsive they are.
Which solution did I use previously and why did I switch?
We are also using Tableau. We use Tableau right now, and we are likely introducing Microsoft BI in-house in the near future. For now, we just have customers that use it.
How was the initial setup?
We found the initial setup to be straightforward. It's not a difficult implementation and I wouldn't describe it as complex. A company setting up the solution for the first time shouldn't have any problem doing so.
What's my experience with pricing, setup cost, and licensing?
We're still in the process of licensing the model. We don't have it set up yet. My understanding is that we will pay for licensing on a yearly basis. I don't have the exact figures in terms of the costs.
Which other solutions did I evaluate?
Right now, I am looking to do a comparison between Tableau, Power BI, MicroStrategy, and Pyramid Analytics. I have not had a chance to really dig too deep into research.
What other advice do I have?
We are just customers and end-users. We don't have a business relationship with Microsoft.
We are using the most recent version of the solution at this time.
We're still exploring the solution and haven't fully implemented it yet.
I would rate the solution at an eight out of ten. It's very user-friendly and so far I have had a good experience.
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: My company does not have a business relationship with this vendor other than being a customer.
Business Application Group Manager at OBASE
Scalable with various licensing options and offers good technical support
Pros and Cons
- "Technical support is quite good."
- "The licensing needs improvement. There needs to be a middle option between Pro and Premium versions."
What is our primary use case?
We primarily sell Power BI licenses.
Mostly, we focus on the retail industry. Usually, we are using the Power BI reports for dashboards. We are also providing our customers with some data warehouse reporting. Basically, we do long-term categorization of stock and inventory numbers and sales figures so that they can compare the sales and stocks to the inventory numbers.
We tend to deal with physical inventory reports. We tend not to deal with the solution for financial operations.
What is most valuable?
The solution has different licensing tiers.
The product can scale if you need it to.
Technical support is quite good.
With the cloud deployment, there's no setup required.
The product works well for small or mid-level organizations.
What needs improvement?
The solution's stability could be improved. In the retail industry, due to issues with information updating and data uploading. Clients may end up pricing items wrong as they could accidentally base their choices on old or wrong data.
The licensing needs improvement. There needs to be a middle option between Pro and Premium versions. It could also be less expensive.
For how long have I used the solution?
While we have experience with Microsoft tools for the past ten years, I personally have had experience with Microsoft BI for the past two or so years.
What do I think about the stability of the solution?
The solution is not really stable. I've faced a lot of limitations especially in terms of some data flows updates. We have faced some exceptions. Right now, we have created a case for Microsoft in order to solve some problems we've been having as, right now, there's some sort of system fault.
While the platform is a little more stable, the big problem is the latency issues around customer updates.
In a recent project, in Sweden, we faced an exception in Power BI from the update path. Whenever we refresh the animations and the fact tables, we faced something that said we couldn't upload the data. After 20 minutes we tried to refresh again. We didn't change anything with our reports or platform or anything related to infrastructure or schema. We didn't touch anything. An yet, the data is updated successfully. That leads us to ask the question: what was the problem 20 minutes ago? We still don't know the answer.
That is why we need some stability for the update service. We are deciding some business decisions based on this data. If this data is not updated, we may decide to take the wrong path.
This is very important in the retail industry. For example in the grocery field, sometimes with vegetables or fruits or other products, customers need to decide to change the prices within lock days. They need to decide, based on demand, if they should increase or lower prices. They can't make the correct decisions if the numbers don't update.
What do I think about the scalability of the solution?
The scalability potential actually depends on your licenses. Microsoft provides three licenses. One of them is absolutely free. Another is called Pro. Yet another is per user or Premium. There is a huge difference between the Pro license and the Premium license. There is no need to scale the Pro license or other license models.
When you put the on-premise reports, you can scale out or scale up. It depends on your existing resources. However, in the services as a software (SaaS) version, it actually comes with Microsoft's units or Microsoft resources.
How are customer service and technical support?
We have an ASFP agreement with Microsoft. As a Gold Partner, Microsoft is pretty good and responding automatically and helping us resolve issues.
If a partner does not have an ASFP agreement, they tend to have to go to forums or try to Google answers to their problems.
We are aware that sometimes when we make changes to BI, the solutions might be complex. There might be SQL involved, which needs to be taken into account, for example. We may have to look into other resources and other tools to see if there are interactions that are the issue. However, Microsoft is quite helpful as we work through issues. We're quite satisfied with their level of support.
Which solution did I use previously and why did I switch?
We also work with and sell MicroStrategy in Turkey. 95% of the MicroStrategy projects have been completed with our company. It is a direct competitor with Power BI. My company commonly does consulting for some small and medium markets and for that we recommend Power BI. Whenever we talk about enterprise-level solutions, the company we will use is MicroStrategy.
How was the initial setup?
There isn't much of an installation process, as the solution is on the cloud.
What's my experience with pricing, setup cost, and licensing?
There is a free license, however, it is limited. The Premium license and the Pro license functionalities are very different. Whenever we talk with our customers, they ask "Should we chose the Premium?" We say that "No, you don't need to, as it's too expensive. It is much more expensive than the Pro license." However, the Pro license functionality is not enough for some customers. There is no middle between Pro and the Premium. We need something in between.
The Pro license is maybe suitable for SMBs, small and medium-sized businesses. The premium version is ideal for companies that need to scale up and out.
There also may be some additional costs that can drive up the price.
What other advice do I have?
I prefer this product and I suggest Power BI to all customers, however, we know that if Power BI is a new idea, we make sure to show company-specific data or analytics for analyzing the data and how this solution can analyze everything quickly. That said, it's not for everybody. If all companies tried to put all their reporting expectations in the Power BI, it would not fit their expectations.
It's not a standalone solution. You need other items in your toolbelt. You need, for example, something that can handle raw data, you need warehousing, et cetera.
In general, I would rate the solution eight out of ten.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Reseller
Global Director - HR Technology & Platforms at a manufacturing company with 10,001+ employees
Good visualization with an easy initial setup and good overall stability
Pros and Cons
- "The fact that you can visualize items is great."
- "The solution could be quicker at rendering data."
What is our primary use case?
We primarily use the solution for building dashboards, one-off analytics, and things of that nature that combine data.
How has it helped my organization?
The functions from a standpoint of generating analytics have been really helpful overall. That aspect has helped improve our organization.
What is most valuable?
In general, we are pretty pleased.
The ability to combine the data and to connect with pretty established platforms has been the solution's most valuable aspect to us.
The fact that you can visualize items is great. The visualization power is very good.
The initial setup is straightforward.
What needs improvement?
I don't know if I can pinpoint any specific items that I don't like. However, the more connectors that they provide the better.
I don't use it day in, day out to tell you if it has any kind of functionality items that may be open up for improvement opportunities.
The solution could probably beef up items related to statistics and things to cover the gap between the advanced things that you can do with Tableau. Any kind of advanced statistical analysis would be very helpful in future releases.
The solution could be quicker at rendering data.
For how long have I used the solution?
I've been using the solution for three years or so.
What do I think about the stability of the solution?
The solution is very stable. It's reliable. We've been happy with it. There aren't bugs or glitches. It doesn't crash or freeze.
What do I think about the scalability of the solution?
The solution can scale well if you need it to. That shouldn't be a problem for any organization.
I'm not sure how many people are actually using the solution in our organization. Everybody has been kind of encouraged to leverage the platform on an ongoing basis. However, obviously, those that are holding jobs related to any kind of analytics are probably more prone to using it.
How are customer service and technical support?
I don't tend to deal with technical support. That's probably more on the IT team than on my plate and therefore I don't really know how their tech support works. I can't speak to their knowledgeability and response times.
Which solution did I use previously and why did I switch?
With our company, there were probably those that needed to do advanced analytics that were using solutions like Tableau or Excel.
How was the initial setup?
The initial setup is not complex. It's pretty straightforward. A company shouldn't run into any problems when it comes to setting it up.
What other advice do I have?
We have a pretty strong partnership with Microsoft and we tend to help them develop their product as well.
We are using the latest version of the solution at this time.
I would advise other organizations that the product has a lot to offer and therefore it's worth the investment and the effort.
I would rate the solution at a nine out of ten. Sometimes it could be quite at rendering data, however, overall, we've been happy with the results.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Assistant Vice President at a tech services company with 10,001+ employees
A complete and in-demand solution with good price, integration, and features
Pros and Cons
- "Most of the clients I am interacting with are looking towards Power BI because of the cost and simplicities. It provides an entire feature set and a complete solution. It has tight integration with Office 365, Dynamics 365, Microsoft Technology Stack, and datatypes like R and Python."
- "It should be more scalable for an enterprise-level implementation. When you deploy large data sets, the response has to be faster in Power BI. This is one thing that needs to be improved in it."
What is our primary use case?
I lead the data visualization competency. As a competency leader, my responsibility is to make people grow in this technology. It could be Power BI, Tableau, or QlikView. We are service-oriented, and depending upon the demand, we have to have experienced people and a resource pool ready in these areas. Depending upon the requirement, I decide how many people need to be trained or hired.
What is most valuable?
Most of the clients I am interacting with are looking towards Power BI because of the cost and simplicities. It provides an entire feature set and a complete solution. It has tight integration with Office 365, Dynamics 365, Microsoft Technology Stack, and datatypes like R and Python.
What needs improvement?
It should be more scalable for an enterprise-level implementation. When you deploy large data sets, the response has to be faster in Power BI. This is one thing that needs to be improved in it.
For how long have I used the solution?
I have been using this solution for close to two years.
What do I think about the stability of the solution?
We found no issues. It is an aggregated reporting tool. It cannot handle a detailed level of data. It is meant only for the dashboarding purpose. You need to have your underlying data in an aggregated way, and then it would be faster. It depends on whether you have a live connection or you don't have a live connection.
How are customer service and technical support?
We don't see many issues, but whenever we put a request, they at least respond.
Which solution did I use previously and why did I switch?
I have worked on Tableau. Before Tableau, I have worked with traditional tools, such as SAP BusinessObjects. My team has got experience with Spotfire, but we are not seeing a great demand for Spotfire.
If you ask me for the top three, I would qualify Power BI, then Tableau, and then QlikView. That's the demand that I'm seeing in the market from various customers.
What's my experience with pricing, setup cost, and licensing?
I am satisfied with its price. Its price is very less as compared to Tableau and QlikView.
What other advice do I have?
My first advice is to learn SQL. The foundational knowledge and SQL skills are the most important. You have to be very strong in writing SQL code. You have to improve your mind so that you know what you are writing in Power BI. After that, it is very easy to pick up any front-end reporting tool, such as Power BI or Tableau. After you have good expertise in Power BI, you can slowly learn Python so that you can do good integration. All these efforts would be great for your career.
Being a gold partner of Microsoft for the past few years, we work directly with Microsoft product teams. Sometimes as part of a pre-launch, they also connect with us. If we see a feature or functionality that a client requires, we at least put it across to them. How they prioritize it within their product team is up to them. They prioritize depending on the need of the market and demand from various clients, and they release features accordingly. Sometimes, we also work on a pre-release.
They release new features and functionalities every month. They have also recently released data protection smart narratives. If you look at the Gartner report, they are leading. I see a lot of demand for this solution.
I would rate Microsoft BI an eight out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
Director Comercial at Grupo Consultores
A robust, scalable, and easy-to-deploy solution that helps in constant collaboration and has a lot of online resources
Pros and Cons
- "Constant collaboration is the most valuable. I can build a dashboard, and several co-workers can access this dashboard. We can share information that is important for decision-making. It is a very easy-to-deploy solution. It is compatible with a lot of data sources. It is also very stable and scalable. There is also a very good forum and a lot of help and online training."
- "I would like them to provide a license that just allows us to see dashboards. What I don't like about this solution is that in order to just watch a dashboard, you need a license. Currently, you need to purchase a full license of Power BI Pro just to see something, which is not attractive. If you have a license, you can see a shared dashboard, but you can also build a dashboard or you can collaborate with other people. However, if you only want to see a dashboard, there is no license for that. I only want to see the dashboard, and I don't want to do anything more than watching the information on the dashboard. There is no license that allows you to see a shared dashboard. This is one of the areas of opportunity because I would like a lot of people to be able to see a shared dashboard, not to interact with it or to collaborate online with it. I would like to see more compatibility with non-Microsoft data sources. Given the fact that everything is related to Microsoft Azure and all services available on Microsoft Azure, I see that they're building more connections to Microsoft Azure services instead of other non-Microsoft services. I understand the strategy, but it would be good to have more compatibility with non-Microsoft data sources."
What is our primary use case?
I use Microsoft Power BI for analytics. It is an online service for business intelligence. I use it to analyze every piece of data that I have. My key performance indicators are on Power BI. My sales indicators, such as number of clients, number of sales and region, type of client, type of solution, due to date comparison, and due to year comparison, are really based on the sales of the company. I am using Power BI Pro.
What is most valuable?
Constant collaboration is the most valuable. I can build a dashboard, and several co-workers can access this dashboard. We can share information that is important for decision-making.
It is a very easy-to-deploy solution. It is compatible with a lot of data sources. It is also very stable and scalable. There is also a very good forum and a lot of help and online training.
What needs improvement?
I would like them to provide a license that just allows us to see dashboards. What I don't like about this solution is that in order to just watch a dashboard, you need a license. Currently, you need to purchase a full license of Power BI Pro just to see something, which is not attractive. If you have a license, you can see a shared dashboard, but you can also build a dashboard or you can collaborate with other people. However, if you only want to see a dashboard, there is no license for that. I only want to see the dashboard, and I don't want to do anything more than watching the information on the dashboard. There is no license that allows you to see a shared dashboard. This is one of the areas of opportunity because I would like a lot of people to be able to see a shared dashboard, not to interact with it or to collaborate online with it.
I would like to see more compatibility with non-Microsoft data sources. Given the fact that everything is related to Microsoft Azure and all services available on Microsoft Azure, I see that they're building more connections to Microsoft Azure services instead of other non-Microsoft services. I understand the strategy, but it would be good to have more compatibility with non-Microsoft data sources.
What do I think about the stability of the solution?
It is a very robust and stable solution. We are a company that works with enterprise solutions from SAP and Microsoft. We have worked with companies that have 5,000 users and without a problem. So, it is very robust and stable.
What do I think about the scalability of the solution?
Being a cloud solution, it is very scalable. You can easily scale it based on the usage. If you're using it, you pay for it, and if you're not using it, you stop paying for it.
In our company, Power BI being used by maybe 15 people out of 70. It is a growing solution. Three years ago, we had only five people who were working with Power BI. Now, we are building more and more dashboards for our service desk area, and its usage is growing.
How are customer service and technical support?
I haven't contacted them. We report everything to our own Service Desk, and they are the ones who scale the problem to the manufacturer. This means that every time that we have important issues, they have to be solved in a very decent period of time by the manufacturer. There is a very good response time, and every time we had problems, they were solved. We didn't have anything pending.
How was the initial setup?
Given the fact that it is on the cloud, it is really easy to deploy. It is only about connecting the engine to your data source and start building the dashboards. You can just connect your data. It doesn't matter if it is on-premises or as a service. You can just connect it.
What's my experience with pricing, setup cost, and licensing?
It is based on the usage. If you're using it, you pay for it, and if you're not using it, you stop paying for it.
What other advice do I have?
If your data source is a Microsoft-based data source, this is the best choice. If you have a data source that is not Microsoft-based and is on a non-Microsoft platform, such as MongoDB or Unix, you should see some solutions like MicroStrategy or Qlik. If you have a pure 100% Microsoft-based data source, Microsoft Power BI is the answer. You can do wonders with Microsoft Power BI. It is a very cool solution.
I would rate Microsoft Power BI a nine out of ten.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Software Engineer at syntegra
Easy data source connecting, simple implementation, but needs more financial visuals
Pros and Cons
- "I also find connecting to different data sources is quite simple. Other solutions we were using before were complicated."
- "I think that there should be visuals for financial reporting videos. It should just be a plug and play because there is a lot of coding that goes into it with different clients."
What is our primary use case?
We are an analytics company, and we consult for different companies. Currently, we were doing automation of financial reporting, income statements, balance sheets, cash flow, and different kinds of analysis on revenue and products. We extract data from ERP solutions, accounting data, and then we transform that into financial reports.
What is most valuable?
The data modelling and the use of decks are key features. It is difficult to create financial statements using most BI solutions, with decks it is a bit easier to summarize data and to have cascading totals that you would find in an income statement or balance sheet. Most other solutions, you can not have a moving total but with this solution, we found it very easy to implement.
I also find connecting to different data sources is quite simple. Other solutions we were using before were complicated.
What needs improvement?
I think that there should be visuals for financial reporting videos. It should just be a plug and play because there is a lot of coding that goes into it with different clients. We should have a visual for income statements and other elements, this should be made easier. For example, suppose you are looking at an inventory report, it is all plug and play because you can just use a matrix or a table to summarize the information and the visuals. The systems are more adapted to that kind of area than for financial purposes.
For the next release, I think they need to improve on getting more visuals that are related to the finance side of things. Like I mentioned before, the matrix now is more of an OLAP cube, we are looking into something more adapted to the finance field, such as a drag and drop where you can build an income statement very quickly without too much code. This would be a nice addition.
As far as I understand Microsoft has two solutions that are similar, Power BI Report Builder and Power BI Desktop. The features that you get in Power BI Desktop are more advanced than the features that you get in Power BI Report Builder. They should just merge the two and move forward this way. There is no reason to have two different applications serving the same purpose.
For how long have I used the solution?
I have been using the solution for 18 months.
What do I think about the stability of the solution?
The biggest problem we have had is refreshing with MySQL, we are using a MySQL backend. It has to refresh all the data at once and store it in a cache, is my understanding. I am not sure where Power BI stores the data that it gets from the warehouse, this takes some time. If there are interruptions in the network, then the figures become messed up at some point. It should either commit all the data or it should not commit anything at all if there are errors. I think that is the biggest issue we have had so far.
What do I think about the scalability of the solution?
We are rolling out the solution to various clients and one of them is a large client in the manufacturing industry. The solution scalability is very good, we can do a lot with it.
We have about 40 users at the moment. As we continue to expand, we are looking at approximately 20 companies with about five users at a time. Currently, we have done five companies, but I think by the end of this quarter, we should have about 100 users in total. At the end of the year, we hope to have at least 200 users from different financial departments in different companies. It is my team that does the financial reporting, we also have other companies that have the operations and logistics. We are looking to probably double that figure because eventually, we should be moving to the enterprise license. We had seen that the enterprise license will be beneficial to us. If everything goes as planned, we are looking at about 500 users at some point.
How are customer service and technical support?
At the moment we have not needed much technical support from Microsoft. Most of the problems we have faced have either been resolved by someone else on the forums available. We also have an expert consultant in the UK who helps us. The areas that have needed assistance has been very minimal.
Which solution did I use previously and why did I switch?
We have used Eclipse BIRT and Knowage in the past but were not as good and more complicated. We find Power BI is more direct, it is much easier to connect to other data sources and so forth.
How was the initial setup?
The setup was very straightforward. You just download through the Windows Store or through the website, then you just start to connect your databases.
What about the implementation team?
The first deployment took approximately four months. The data preparation took most of the time, once we got into Power BI we had most of our financial reports in a month.
Part of our implementation strategy was to get the requirements from the customer, documents, information on what they were using before, key performance indicators and other information. Afterwards, we started to build the data warehouse with the requirements in mind. We tried to mimic the reports that they were using before when we were building the Power BI reports. We tried as much as possible to have reports that look similar to the reports to meet our customer's needs.
There is a similarity between Microsoft Excel and Power BI. If you understand one it make the other easier to understand. If you grasp Excel, it is easy to grasp Power BI as a user. We wanted to make it as similar as possible to the Microsoft Excel experience, with the drill-downs and the pivot tables and so forth. I think with the matrix in Power BI, it is more or less similar, it is the same experience. To summarize our implementation strategy, it was to try to mimic the reports as much as possible and then add more features that are available in Power BI.
What's my experience with pricing, setup cost, and licensing?
We pay on a monthly basis which is approximately $10 per user on the Microsoft Power BI Pro license. At the moment we are still down at 400 users, but once we reach 500 users, we will move to the premium edition. The premium is $5,000 for unlimited users. Currently, with the 40 users, the cost is roughly $500.
There can be some additional cost, for instance, it was an internal decision to have an on-premises gateway set up with the standard Windows Server installed on it. We had to set up this server on our side, which costs us no more than $400. This was important because we needed something to allow our reports to refresh on a regular interval without people using the personal gateways.
What other advice do I have?
I would advise those thinking about implementing the solution to compare different products to see what is on the market. They have to look at the pricing which is what we looked at initially, I think it quite affordable. Additionally, research the infrastructure that is required and the cost per user for the different BI solutions. Some of the solutions are cheap, such as Eclipse BIRT and Knowage, but it takes a lot of efforts to get your reports out with them.
With this solution, it is more of a drag and drop scenario. You have a quicker delivery time as compared to the traditional or the older BI solutions.
The biggest lesson I have learned with working with this solution has been in the area of data warehousing, you should develop something that is more like a star schema when building a BI solution, especially with this solution. It makes things much easier. We did not favour the star schema, we preferred the snowflake approach. However, data modelling is easier when you use the star schema.
I rate Microsoft BI a seven out of ten.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.

Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros
sharing their opinions.
Updated: May 2025
Popular Comparisons
Teradata
IBM Cognos
Amazon QuickSight
SAP Analytics Cloud
SAP BusinessObjects Business Intelligence Platform
Oracle OBIEE
MicroStrategy
Oracle Analytics Cloud
QlikView
Looker Studio
TIBCO Spotfire
Salesforce Einstein Analytics
Microsoft SQL Server Reporting Services
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?