Try our new research platform with insights from 80,000+ expert users
PeerSpot user
Head of IT at a construction company with 10,001+ employees
Real User
Mar 4, 2018
Users already using Excel can generate new reports and dashboards within minutes
Pros and Cons
  • "It is in the cloud, which makes it easy for mobile access of reports and data."
  • "Users already using Excel can generate new reports and dashboards within minutes."
  • "Initial setup was very straightforward. Users can get up and running reporting on databases within minutes."
  • "The business users have taken to Microsoft BI like a duck to water."
  • "Real-time refreshing for SAP BW would be nice. We know its on the radar for the development team at MS. ​"
  • "Not having to login again after a mobile app upgrade. A simple login on mobile would be great."
  • "Real-time refreshing for SAP BW would be nice."

What is our primary use case?

Microsoft Power BI gives a true self-service tool to the user. The IT team can focus on ensuring that the database is in a good place. It is also in the cloud, which makes it easy for mobile access of reports and data. 

How has it helped my organization?

The business users have taken to Microsoft BI like a duck to water. It requires a low amount of training. Users already using Excel can generate new reports and dashboards within minutes.

What needs improvement?

  • Real-time refreshing for SAP BW would be nice. We know its on the radar for the development team at MS. 
  • Not having to login again after a mobile app upgrade. A simple login on mobile would be great. 

For how long have I used the solution?

One to three years.
Buyer's Guide
Microsoft Power BI
March 2026
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: March 2026.
884,976 professionals have used our research since 2012.

What do I think about the stability of the solution?

None.

What do I think about the scalability of the solution?

None.

How are customer service and support?

They are fabulous.

Which solution did I use previously and why did I switch?

The previous products include Tableau, Cognos, BusinessObjects, and Sisense. All of them have high price tags! Why pay and get ripped off for these products when you have Power BI? It will give you just as much, growing every month at an acceptable cost model.

Want to waste a lot of money? Then go for the others, I can recommend BusinessObjects as a great way to burn your money.

How was the initial setup?

Initial setup was very straightforward. Users can get up and running reporting on databases within minutes. I can read a number of databases including a good old Excel spreadsheet. 

What about the implementation team?

Internal Team. It is that easy. However, we did get a third party to do the training to key users for us. The course was tailored to our business. 

What was our ROI?

Paid for itself in the first month. 

What's my experience with pricing, setup cost, and licensing?

Make it low in cost. It is a no-brainer! 

Remove the cost of a licence to show a dashboard within SharePoint. Why should readers of a dashboard have to pay to view? 

Which other solutions did I evaluate?

Globally, we evaluated a number of products, including Salesforce's product, Microsoft won on the ground of simple functionally and cost. 

What other advice do I have?

Love that fact that we have a great development team that is moving the product forward every month. 

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
it_user825114 - PeerSpot reviewer
Senior Manager with 10,001+ employees
Real User
Feb 27, 2018
Ease of development and maintenance
Pros and Cons
  • "Ease of development and maintenance."
  • "Ease of development and maintenance."
  • "Needs single sign-on."
  • "Needs single sign-on."

What is our primary use case?

  • P&L
  • Revenue
  • Logistics
  • IT services
  • Stock control
  • Costs
  • Sales

How has it helped my organization?

  • Established a culture of management by indicators.
  • Improvement of services
  • Greater visibility of results

What is most valuable?

  • Predictable cloud environment
  • High performance
  • Ease of development and maintenance

What needs improvement?

  • Delta update
  • More than 10 GB of space
  • Single sign-on
  • More than 30 Windows to update by Power Bi gateway.

For how long have I used the solution?

One to three years.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Microsoft Power BI
March 2026
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: March 2026.
884,976 professionals have used our research since 2012.
it_user825090 - PeerSpot reviewer
Project Manager with 51-200 employees
User
Feb 27, 2018
It helped identify bad data
Pros and Cons
  • "Helped identify bad data, enabling the corrections needed to the data for management."
  • "Helped identify bad data, enabling the corrections needed to the data for management."
  • "​It needs more graphics and overlays."
  • "​It needs more analytic tools."
  • "It needs more analytic tools."

What is our primary use case?

Our primary use cases for this solution are Health and Wellness claims and short-term and long-term disability data.

How has it helped my organization?

It helped identify bad data, enabling the corrections needed to the data for management.

What is most valuable?

  • Ease of use
  • Dashboard
  • Easy access to databases and spreadsheets
  • Multi-table access

What needs improvement?

  • More graphics and overlays
  • More analytic tools
  • More interfaces to databases, especially multi-table management

For how long have I used the solution?

Three to five years.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
PeerSpot user
Database Expert & BI Developer at a outsourcing company with 10,001+ employees
Real User
Top 20
Oct 30, 2017
We were able to improve the performance of our reporting system. Monitoring features and SSIS Connectors need improvement.
Pros and Cons
  • "Provides a full platform (database, ETL, reporting, analysis, and so on)"
  • "Microsoft offers us a full platform, which we use to develop and deploy our BI solution quickly and easily."
  • "I have to write scripts to query data for analyzing performance."
  • "Microsoft needs to provide more drivers to connect other data sources in a native way."
  • "Monitoring features: I need Microsoft to provide a set of tools to help me monitor Microsoft's products."

How has it helped my organization?

By building the multi-dimensional database with Analysis Services, we were able to improve the performance of our reporting system. Now, our end-users can see the data stories quickly through Excel, Power BI tools, etc.

What is most valuable?

It provides a full platform for our BI solution (database, ETL, reporting, analysis, and so on).

What needs improvement?

  • Monitoring features: I need Microsoft to provide a set of tools to help me monitor Microsoft's products. For example, when I need to investigate the performance issues of SSIS packages, I do not have a tool, instead I have to write scripts to query data for analyzing performance.
  • SSIS Connectors: Microsoft needs to provide more drivers to connect other data sources in a native way, which they are doing very well in Power BI, and that we can connect and process data from JSON, SOAP, SAP, Salesforce, and so on.

What do I think about the stability of the solution?

No.

What do I think about the scalability of the solution?

No.

How is customer service and technical support?

It is not excellent, but enough to resolve our issues.

How was the initial setup?

It is quite easy to setup.

Which other solutions did I evaluate?

There are a lot of factors which we analyze and consider before we choose any product. In case we need a solution that we can develop, deploy quickly, and adapt to our business changes, Microsoft is the best candidate.

What other advice do I have?

Microsoft offers us a full platform, which we use to develop and deploy our BI solution quickly and easily. It also provides both of these infrastructure for use: On-Premise and Azure Cloud. They are very flexible.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Partner at a consultancy with 11-50 employees
Real User
Sep 26, 2017
Competitors' products have more functionality, though the self-service aspect is good
Pros and Cons
  • "We can see that it's really improved the way end users can do their own graphs and pick their own fields of information and present that in a nice way."
  • "We are a consultancy firm, helping our clients with billing and business intelligence solutions, and we can see that it's really improved the way end users can do their own graphs and pick their own fields of information and present that in a nice way."
  • "The way you navigate the product, compared to other products in this industry, that could be improved a bit."
  • "The way you navigate the product, compared to other products in this industry, could be improved a bit."

What is most valuable?

The self-service part.

How has it helped my organization?

We are a consultancy firm, helping our clients with billing and business intelligence solutions. We can see that it's really improved the way end users can do their own graphs and pick their own fields of information and present that in a nice way.

What needs improvement?

The navigation. The way you navigate the product, compared to other products in this industry, that could be improved a bit. It's user friendly, but you would like to have it even more user friendly.

When you do selections in one tab in Report, and then you move to the next tab, then you have to do your selections again. So one tab as a global, central selection possibility would help.

If you compare to QlikView, there's still a lot of functionality that QlikView has that Power BI doesn't. For most companies, Power BI is good enough, especially if you consider the price tag it's an easy choice. But it still has some catching up to do to match the functionality in QlikView.

For how long have I used the solution?

Eight to 10 months.

What do I think about the stability of the solution?

It feels very stable. A bit slow sometimes when you change stuff and you want to refresh data and apply it to the data model in your queries. You want to apply that to your reports and dashboards and it can be a bit slow sometimes.

What do I think about the scalability of the solution?

We don't have that experience yet. We still don't know how it is to deploy it in larger scales. So, that's my concern, but I haven't seen the scalability issues at our clients.

How are customer service and technical support?

No, not yet. There are a lot of self-training videos and such out there on the internet and on the Microsoft websites.

Which solution did I use previously and why did I switch?

QlikView and Qlik Sense. We felt demand in the market for Microsoft Power BI. Also, within my company we are selling services around Microsoft Dynamics, and Microsoft Power BI hooks very well into the other Microsoft products.

How was the initial setup?

It was pretty straightforward. Not much to set up. Cloud service and desktop client that you need to download and install, but if you have worked with other similar tools then you and know about that.

Which other solutions did I evaluate?

We are constantly looking for what is hot in the market and this has really come up as a rising star on the BI market, so it was not so much of a question about it at all. Quite obvious.

What other advice do I have?

There are some limitations in regards to the navigation part.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
PeerSpot user
Principal Business Intelligence Analyst at a logistics company with 1,001-5,000 employees
Vendor
Sep 17, 2017
The ability to perform complex business modeling through DAX calculations stands out in a crowd
Pros and Cons
  • "SSRS and the Tabular server/Vertipaq engine/DAX are probably the two most valuable components."
  • "The breadth of products do a fine job at enabling the delivery of data and insights to the right people, in the right format, at the right time."
  • "The visualization aspect, while being the most visible to business users, also happens the be the weakest point in the entire Microsoft BI stack."
  • "The visualization aspect, while being the most visible to business users, also happens to be the weakest point in the entire Microsoft BI stack."

What is most valuable?

SSRS and the Tabular server/Vertipaq engine/DAX are probably the two most valuable components, leaving out SQL Server (and Azure versions of it, including the Azure warehouse and big data technologies). SSRS's display functionality is resoundingly flexible, and by comparison to other vendors, relatively easy to learn. SSAS Tabular performs very well with modest effort in design, and the ability to perform complex business modeling through DAX calculations stands out in a crowd.

How has it helped my organization?

Microsoft BI really entails a whole catalog of products. The relative ease with which these products work together is where the primary value comes into play. When you buy SQL Server Enterprise, you automatically have access to SSAS, which can handle Tabular or multidimensional cubes and data mining, SSIS offering a pretty comprehensive integration toolset, SSRS, covering just about any paginated and subscription-based reporting, and of course all of the in-built features of SQL Server, the individual useful features of which there are too many to spout out here. Each of these components work well enough in isolation, or as part of a larger ecosystem with other vendors, but together are a well-integrated machine that can handle end-to-end needs on the entire lifecycle of data. Being one of the more popular vendors, Microsoft products are also the first compatibility for other vendors' products. The breadth of products do a fine job at enabling the delivery of data and insights to the right people, in the right format, at the right time. Doing so efficiently/quickly is where a huge amount of value comes in. Many other enterprise vendors are capable, but are either slower to execute, more work to maintain, cost much more to find talent and skills for, or some combination of all of the above.

What needs improvement?

No product is perfect, and the Microsoft stack is no exception. The first things that come to mind are Microsoft's recent shift in strategy to focus on cloud first. While this makes sense for them, it leaves the on-premise products lagging in support and new features, while the vast majority of users (mid to large corporations) are still using on-premise solutions and/or are cloud-averse. For example, the announcement that the pricing model for Power BI would change, simultaneously rolling out both Power BI Premium and Power BI Report Server created a great deal of confusion for people who were very enthusiastic about the product. The failures to address concerns with the speed and nature of the changes were felt by users across the spectrum, and it was a situation created by their cloud-first strategy. Similarly, if you look at the tried and true on-premise options for data processing, interfacing with emerging technologies, especially big data technologies, lags behind. This is considerably less true for Azure users, but that is specifically a cloud offering, which again, many corporate entities are not yet ready to embrace.

It's easy to think of BI as only the visualization aspect of data, and that point of contact between users and data is absolutely where the rubber meets the road in BI. In reality, there are a whole stack of tools and concepts behind the visualization that enable that interaction - from security, data governance, integration, performance, network and infrastructure, and automation... there are many facets to BI as a system. The visualization aspect, while being the most visible to business users, also happens the be the weakest point in the entire Microsoft BI stack. The PowerBI visualization experience is underwhelming in almost every way compared to many alternatives.

Another difficulty is navigating the many products within the suite. There are many components, and each component has many versions. Dealing with feature and compatibility issues with so many versions of so many products can be very frustrating at times. Microsoft does not do itself any favors on this front with the way they name their products. "PowerBI", for example, could be in reference to the desktop design tool, a cloud-based service for publishing and administering data models (which comes with three distinctively different pricing models, the features of which are different and not interchangable), or an on-premise server solution replacing SSRS. You'll make yourself dizzy looking at the Azure services offered. The good news is the sky's the limit, the bad news is you'll have to navigate some pretty cloudy areas to make heads or tales of what to actually use.

For how long have I used the solution?

Four years, using largely SQL Server 2012 and related versions/components.

What do I think about the stability of the solution?

In general, no. Most stability issues encountered have been more related to network or infrastructure, and not the products being used.

What do I think about the scalability of the solution?

As with any system, good design is paramount. I have certainly run into times when performance suffers, or changes and enhancements are slow and expensive. In every case, redesign has solved the issues. As hardware improves, and the many options (especially in the Azure and big data space) continue to evolve, designing for scale has become easier and easier. One of the difficulties that naturally occurs in this ecosystem is simply knowing how to design with so many options that can potentially do the same or similar task.

How is customer service and technical support?

I have experienced mixed results on this front. We have had some very available and supportive account reps at times, and other times not so much. My biggest complaint would have to be that the disorganization from Microsoft's side makes the results on this front inconsistent.

How was the initial setup?

Depends on which components we are talking about. For reference, however, I don't think there is a single Microsoft component that was as painful as any given Oracle component to work with.

What other advice do I have?

Do your homework when deciding what components to leverage. The worst thing you can do is try to use them all. The gamut of products under the Microsoft BI banner enables every form of BI - choose the ones that serve your specific purposes, and leave the rest on the table until a new need arises.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer96678 - PeerSpot reviewer
Managing Director at a tech services company with 1-10 employees
Real User
Sep 14, 2017
It reduces the time needed to generate reporting and provides an overview of company performance
Pros and Cons
  • "It reduces the time needed to generate reporting for an organization, allowing management to have an overview of how the company performs."
  • "The BI reporting still relies on historical transactions."

What is most valuable?

Standardized solution that comes with data warehouse and BI cubes straight out of the box for deployment for both Dynamics NAV and AX products. Enhanced wizard allowing for customization of BI Solution without having to go through SQL scripts to generate additional measures and dimensions.

How has it helped my organization?

It reduces the time needed to generate reporting for an organization, allowing management to have an overview of how the company performs. Afterwards, it allows the company to formulate strategies to improve itself.

What needs improvement?

To add-in the functionality of AI into the reporting, so this can improve further on the product as it is currently. The BI reporting still relies on historical transactions.

For how long have I used the solution?

Five years.

What do I think about the stability of the solution?

No. It works on all versions of NAV and AX.

What do I think about the scalability of the solution?

The current deployment of the solution is up to 2TB. Do note that it still is not to the “Big Data” level.

How is customer service and technical support?

We have our own technical team who supports the BI solution. We usually solve 95% of the issues encountered. For those that can’t be resolved, it is escalated to our HQ.

How was the initial setup?

It is fairly straightforward. As long as there is a connection to the server which houses the NAV/AX database and all the data warehouse, since bi cubes are generated from the BI solution, without any need for user intervention.

What other advice do I have?

For the first project, we will advise using consultants to assist on the implementation, so the dos and don’ts of the solution can be known in the first instance without having to trial and error the solution.

Disclosure: My company has a business relationship with this vendor other than being a customer. We are a direct distributor of the solution in Asia market.
PeerSpot user
PeerSpot user
Business Intelligence Architect at a tech services company
Real User
Jul 13, 2017
Data integration enabled my organization to easily pool data from our varied system into one data warehouse.​
Pros and Cons
  • "Data integration enabled my organization to easily pool data from our varied system into one data warehouse."
  • "Data integration enabled my organization to easily pool data from our varied system into one data warehouse."
  • "SSMS & SSRS."
  • "SSRS reporting portal cannot run on tablets, iPads and all other mobile devices."

What is most valuable?

Power Query, Power Pivot, Power View & SQL Server Data Tools comprising of (SSIS, SSAS, SSRS).

How has it helped my organization?

Data integration enabled my organization to easily pool data from our varied system into one data warehouse.

SSRS improved our report delivery timings and the Power BI feature empowered the data users.

Power View improved the visualization of our reporting and dashboards.

What needs improvement?

SSMS & SSRS.

For how long have I used the solution?

For over five years.

What do I think about the stability of the solution?

Yes.

What do I think about the scalability of the solution?

Yes, SSRS reporting portal cannot run on tablets, iPads and all other mobile devices. But SQL 2016 has been shipped with this capability.

How are customer service and technical support?

Microsoft has a lot of products, hence some products are given little attention and VS is one of them, so I would say their technical support for the BI suite is average.

Which solution did I use previously and why did I switch?

No.

How was the initial setup?

The initial setup was fairly simple and straight forward, I must say.

What's my experience with pricing, setup cost, and licensing?

To others, I would advise that Microsoft BI products are rightly priced and the licensing is easy to follow and to fulfill.

Which other solutions did I evaluate?

Yes, Tableau.

What other advice do I have?

For users intending to use the product in exclusively Microsoft environment, this product will meet most of your requirement if not all.

If there is a need for integration with other vendors’ products precautionary measures must be taken.

SQL 2016 is bringing and offering that support for mobile BI, so it would be great to give it a try.

If you are comfortable with MS Excel spreadsheets, then Power BI is your thing as it has the same look and feel of Excel, actually, it is embedded in Excel.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 2026
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.