Try our new research platform with insights from 80,000+ expert users
Lead Senior Engineer at a manufacturing company with 10,001+ employees
Real User
Stable, scalable and well suited for specific applications
Pros and Cons
  • "We have found the product to be scalable."
  • "If you need data in real-time, it's not an ideal solution."

What is our primary use case?

The solution is basically used for data. It's on a proprietary piece of equipment on which we collect data. We look at impurities in molten metal, and it's a database and it keeps track of all the batches that we have through the furnace that we have. It tells when it's dirty and stuff like that. It's a large database that we keep track of the history of all the ingots that we run.

What is most valuable?

The solution serves its purpose. When you have the recurring cost every year on this other project, Qlik Sense didn't fit with it as you'd have to have Qlik Sense plus something else. 

As long as you don't need the data in real-time, it's okay.

The solution is stable.

We have found the product to be scalable. 

What needs improvement?

We looked at it for these two new projects too, however, we needed more real-time data on this other project and so it wasn't a good solution and we thought Qlik Sense would work better.

If you need data in real-time, it's not an ideal solution.

For how long have I used the solution?

I've dealt with the solution for about a year or so at this point.

Buyer's Guide
Microsoft Power BI
August 2025
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: August 2025.
865,295 professionals have used our research since 2012.

What do I think about the stability of the solution?

From what I have seen, the solution seems to be very stable. There are no bugs or glitches and it doesn't crash or freeze. It's reliable. 

What do I think about the scalability of the solution?

The scalability of the product has been fine. We can expand it if we want to.

How are customer service and support?

I've never contacted technical support. I cannot speak to how helpful or responsive they are. 

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

We have more of an industrial type application and we're going to have Tulip interface with Qlik Sense or we're just going to use Domo's platform. Domo is more expensive, a little bit more expensive, however, one of my colleagues here already used Domo and he really liked it, so we're gearing towards Domo. We haven't purchased it yet.

Which other solutions did I evaluate?

We looked at Qlik Sense. However, when you have the recurring cost every year on this other project, Qlik Sense didn't fit with it because you'd have to have Qlik Sense plus something else.

What other advice do I have?

Our corporate office may have some sort of agreement with Microsoft. We're just an end-user.

Corporate is kind of pushing Microsoft BI, and they have questions about using it for this project, however, we had an IT consultant that said it's not a good solution.

I would rate the solution at an eight out of ten. It's not ideal for every application, however, it works pretty well.

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.
PeerSpot user
Owner at BNS
Real User
Top 20
Reliable with good reporting, easy to setup, can capable of scaling
Pros and Cons
  • "The reports are easy to create."
  • "The orchestration module for refreshing data flows is something that is missing and we have to do it manually."

What is our primary use case?

We are software developers. We generate data using the basic data connectors that Microsoft provides. We just follow the importing and exporting data around, the Azure platform.

We are doing C# development. We use an SQL server, and we use Power BI. Those are the main three technologies, and then it's just Microsoft to put it together.

We use this solution to create business intelligence reports for the executive users of our applications. We are creating standard business applications like ERP and CRM and e-commerce type applications. Then, we extract a sample of the data, build a simple data warehouse, in the Power BI service, and create some BI reports.

What is most valuable?

The data visualisation is very attractive from the user's point of view. Users see their reports and think "Wow - that is amazing". 

However, it is much harder to prepare data for reporting. I would say 95% of your development time is spent gathering, cleaning, and modelling data. However once that is done reporting is easy.

What needs improvement?

The capacity needs improvement. It is limited in its capacity in power.

Some of its features are incredibly difficult to understand. There is a learning curve to do the more sophisticated things. For example, paginated reports are complicated. But in general, Power BI, it's not an end-user tool, however much Microsoft pretended it is. We just treat it is like another tool that we use and we deliver the reports to our clients.

The orchestration module for refreshing data flows is something that is missing and we have to do it manually. It should be one of the admin features of Microsoft BI.

For how long have I used the solution?

I have been working with Microsoft BI for 15 months.

We are using the latest version.

What do I think about the stability of the solution?

It is a reliable solution. 

What do I think about the scalability of the solution?

I haven't tried to scale it, but in theory, I know that is capable. Power BI Premium is easy to scale as long as you have the money.

Inside the business, we only have one user, and outside the business, we have our clients where we have four developers who use this solution.

Our clients are medium-sized companies with 50 to 100 users.

How are customer service and technical support?

I have not contacted technical support. Google provides the information that we need.

How was the initial setup?

The initial setup is straightforward.

It can take a couple of hours to deploy the gateways, then there is the development of it.

It doesn't require maintenance, but we are forever enhancing the reports. In general, it works without problems.

What about the implementation team?

We are developers, we can complete the installation ourselves.

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

We view it as an expensive product. 

Most of our clients cannot afford the premium capacity. 

We just make do with Power BI pro features, which is always a big shame because we know that the premium version has a lot of features that we would like to use, and are not available to us.

There are a few different licensing models.

It ends up being complicated and people don't like paying for things. It's okay if you're working for a large corporation because they can obviously spend thousands of pounds every month on licenses, but our customers cannot.

Licensing is paid on a monthly basis.

What other advice do I have?

Power BI has approximately 20 new features that come out every month. You just have to be patient and eventually, the features come out.

My advice to others would be to do your homework. It's one of those things where you have to get past the marketing. The marketing message is not helpful.

I would suggest that if you are going to use Power BI, you need to use developers who understand what it can do, what it can't do, and how it works. 

Then they will then guide you to say, this is the type of report you can expect. 

It took me a long time to realize what you can and cannot do with Power BI.

That's why I suggest doing your homework first. It's not as wonderful as Microsoft pretends it to be, but it's not bad, and I am not knocking it, but you have to cut out all the hype that comes with it.

I would rate Microsoft BI a nine out of ten.

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. Partner
PeerSpot user
Buyer's Guide
Microsoft Power BI
August 2025
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: August 2025.
865,295 professionals have used our research since 2012.
Managing Director at Streamline Strategies
Reseller
Easy to use, integrates well, and gives us the ability to collaborate and keep track of everything
Pros and Cons
  • "It is easy to use. It has got a desktop where people can develop their own dashboards. Basically, we have figured out how to connect finance contracts and all programs for the government agency. So, they can see everything in a dashboard. So, it is very easy to use from a technical standpoint of view."
  • "Its desktop tool is a little bit memory CPU intensive, and it can be improved, but the machines nowadays come with a lot of memory. For the desktop users who are using it on the desktop, we recommend that they do an upgrade. It is a minor issue. We can fix it on the desktop."

What is our primary use case?

We are using it for financial analytics and reporting. We are using it to keep a track of projects and being able to degrade the projects. We are also using it for contract closeout.

My technical guy has been using the first version of it since it came out, but we are getting ready to upgrade to the newer version. It comes along in a bundle with the 365 Enterprise version.

It is on the cloud. We're probably going to run a hybrid because we want to be able to move around. If anything happens or if needed, we can move from platform to platform.

How has it helped my organization?

We can see things from a bird's eye view. We can do predictive analytics. I can tell who's capable, who's doing what, when and how much money they're spending, and how fast they're burning. So, it gives us a bird's eye view over the financials and the money. It basically gives us the ability to collaborate and keep track of everything that's going on in an organization. We were able to bring all the collaboration and tasks right into Power BI.

What is most valuable?

It is easy to use. It has got a desktop where people can develop their own dashboards. Basically, we have figured out how to connect finance contracts and all programs for the government agency. So, they can see everything in a dashboard. So, it is very easy to use from a technical standpoint of view. We publish a report every morning for the government, and we got all the data into one place. The data can be refreshed. We are using the API to connect to various systems, such as the financial system, contract writing system, and workflow. We are able to bring things from NIPA, which is their budget and where they keep all their money. There are a lot of features, but the most important thing is it is very easy to use. It is not like Tableau. With Tableau, you've almost got to be a rocket scientist.

On the user side, it is quite simple. If you know how to run a pivot table, and then you can do almost anything. All the data is right there in the database. So, if you understand pivot tables and know how they are run, and you know the reports that you are looking for, then everything becomes very easy to run in your organization.

What needs improvement?

Its desktop tool is a little bit memory CPU intensive, and it can be improved, but the machines nowadays come with a lot of memory. For the desktop users who are using it on the desktop, we recommend that they do an upgrade. It is a minor issue. We can fix it on the desktop.

For how long have I used the solution?

We've been using Microsoft BI for about four and a half years.

What do I think about the stability of the solution?

Its stability is pretty good. It is pretty stable.

What do I think about the scalability of the solution?

I would rate it an eight out of 10 in terms of scalability. Currently, we are running a pilot. We're doing a pilot for army headquarters. They dictate what happens and what they use. Currently, there are 10 users, but I'm looking to go up to at least a hundred. 

We got an architect and an assistant administrator. We got a staff of three and a half people because people take vacations or sick leaves. The good part about it is that these people can work from anywhere.

How are customer service and technical support?

We are a Microsoft reseller. We have partnered with Microsoft. We have developed a relationship with their technical folks over the years. So, we kind of go directly to them. My partner came from Microsoft, so he has a very good relationship with a few technical folks. So, we, kind of, have some special privileges that a couple of other vendors don't have.

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

As a matter of fact, we had built a tool, but it took so long to get it vetted and get it through to ATOs. That's when we decided to convert to Microsoft Power BI. It has already been vetted and approved in the army environment. It is an approved government site for cloud services. We were looking for the easiest path, and that's why we worked with Microsoft BI. They've already been embedded into the government. It is bundled with Office 365.

How was the initial setup?

If my technical person had to rate it, he would say very easy. All we need is to have the software.

What about the implementation team?

It was done in-house.

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

They are charging us by users in storage, and there is a license fee. My financial people handle all that. The client has already worked out a contract with Microsoft, and basically, we're getting government prices.

What other advice do I have?

The backend is the most important part. We understand its backend. We implemented the on-time system for an airport. We don't find its modeling complicated. We set up the back offices and get all the modeling done and everything connected. The customer doesn't even see that. They only see the part where they're running their reports and doing the analytics or whatever they need to do. We give them all the information at their fingertips.

Everybody is going to Business Analytics. A lot of people don't understand the difference between analytics and coding, but that's something for me to teach and educate them on.

I would advise doing your testing and environment setup. You should evaluate your product very well and figure out what platform your organization is running on. You should be careful and look at how well it integrates with other products. If you're not in a Microsoft environment, it is going to be quite difficult. Oracle and Microsoft are competitive. So, you go with one or the other. The reason why I like Microsoft is that they integrate with all applications. Microsoft controls 99% of the desktops.

I would rate Microsoft BI a nine out of 10.

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 has a business relationship with this vendor other than being a customer.
PeerSpot user
Nurul Asyikin Wahab - PeerSpot reviewer
Management Design Civil Structure at Malaysia Airports Holdings Bhd
Real User
Top 10
Great for visualizing data with good flexibility and an excellent dashboard
Pros and Cons
  • "The visuals are great and make everything look very professional. We can change the look and feel or manipulate the data according to our requirements. It's extremely flexible."
  • "It's quite difficult to learn how to use Power BI."

What is most valuable?

Microsoft Power BI is a very powerful tool. It allows us to extract data from Excel or Share Point. 

We can send various project reports from the dashboard to management. It allows us to set up our own preferences. 

We can work with all sorts of data from the previous year or two. With that native data, we can have everything in one dashboard that accurately reflects the reporting. The visuals are great and make everything look very professional. We can change the look and feel or manipulate the data according to our requirements. It's extremely flexible. 

The solution has been very stable so far.

We find the product to be quite scalable. 

What needs improvement?

It's quite difficult to learn how to use Power BI. I'm not from the IT background, and I've been given the license to use the Power BI, however, I find that the support and video demos from Microsoft are not really helpful for me. I don't handle Microsoft BI 24/7. My working time isn't dedicated to using it and learning it. I need it for certain tasks and trying to wrap my head around it, while also handling other duties is difficult. There's too much of a learning curve for beginners.

The cost of the solution is high.

For how long have I used the solution?

We originally started our migration back at the end of 2019. We've used it for a year or two now.

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

The solution can scale. If a company needs to expand it, it can do so. It's not a problem. 

Right now, in our organization, only 15 of us have the full license for the Power BI Pro. Not everyone in the office actually uses it. However, we have over 1,000 people using various other Microsoft products in our company.

How was the initial setup?

As I am not technical, I did not handle the initial setup. We have IT personnel within our organization that handled it. I just gave them my laptop, and they just installed it for me. Occasionally, they can also do it remotely from their office to our office. I never touch it. We just open the apps from the desktop. The process, when do that way, i's quite convenient. It's quite easy for end-users.

What about the implementation team?

We have our own IT team that handles the installation. They either take the laptop or do the installation remotely. In either case, it's handled in-house and not by integrators or consultants. 

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

The solution is quite expensive. 

What other advice do I have?

I'm an end-user of the product, however, I'm not overly technical or in IT.

We have a custom Microsoft setup. We are using a few apps from Microsoft, such as the Microsoft Plan, and we are using Power BI, Power Automate, et cetera. It's all from Microsoft, and it is part of our IT infrastructure. When we combine it together, it is a project and portfolio management solution. It is not a commercial, off-the-shelf product. 

I'm not sure which version number we are using. 

I'd rate the solution at a nine out of ten.

In terms of Microsoft Power BI, for all people who need to do their own reporting or want to visualize their daily work or tasks, in terms of projection, giving others a view on what they are doing, it's a very good tool. It allows users to show projections of what we are doing. Users can grab statistics, which is quite convenient, and understand what they are doing from a visual perspective, which we find quite useful.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Operations & BI Analyst at American Hospital Dubai
Real User
A complete ecosystem with an builtin ETL tool, good integrations with python and R, and support of DAX and Power Query (M languages)
Pros and Cons
  • "Power BI is a complete ecosystem. It has an integrated ETL tool and good connectivity with applications such as Office 365 and SQL. There are also solutions for RPA, such as Microsoft Power Automate and Microsoft Power Apps. Power BI now has integration with Power Query, which has an AI feature for text analytics. Text analytics is a very good feature. This feature is also there in Tableau, but I like it in Power BI because you can write something like, "What is the total sale in the Eastern region?", and it will give you the answer. For example, when you have different types of user opinions, you just run one algorithm and you will have the output that provides the number of positive and negative responses. You can even have a dashboard with positive remarks. This feature has been introduced recently. Power BI supports the DAX and Power Query M languages. These languages are making Power BI very strong in data analytics, and you can do many types of analysis."
  • "It should be more user-friendly. There are very small or tiny icons that you need to move very carefully. If you go a little bit up and down, some of the values change. Its user interface should be improved. It should be like Tableau. Its performance is also slow and should be improved. I definitely feel some sort of speed issues with Power BI. The integration of Excel with Power BI would also be good."

What is our primary use case?

I am currently using it for my professional and training use. I am using the Power BI Premium per user recent scheme announced by Microsoft. In my current company, we are using Tableau.

What is most valuable?

I’m going to go cover my TOP 5 Features for getting you started on your own visualisations so you can be up and running and leveraging Power BI within your own business in no time at all. Power BI Desktop Sure you probably want to build some beautiful and interactive reports and dashboards to share all those insights from your data with your business, but perhaps lacking the experience that report designers, data queries specialists or Excel Power Users have? Well now all your end users can easily access data and build their own reports using a simple yet powerful interface, Power BI Desktop. Power BI Desktop is a free download which provides an excellent canvas for creating your own masterpiece’s or perhaps just a simple report or dashboard tile. Power BI Desktop with its monthly release cycle is constantly evolving with newly added features or enhancements that can ‘bring data alive’ often in just a few minutes or hours. Visibility Data is arguably one of most precious resource that businesses are generating today. The key aim to be able to manipulate and easily combine this valuable data with other datasets, and then have a simple way to gain a deeper understanding of their business. With data often residing across multiple systems and formats, a valuable resource that businesses need is to be able to collate the various datasets and generate different ways to visual and understand it. In order to identify trends and relationships which were not previously visible and help make those important DECISIONS that business need to make every day based on the right facts. With a deeper understanding that comes from interpreting data in a visual form, the data world has become even more important for a business to be able to leverage and gain the competitive edge it needs; so it’s no wonder that Microsoft’s BI can provide so much value with the data-shaping and modelling capabilities to unlock hidden insights. Custom Visualisations Every business has its own culture and way of doing things, sometimes the ‘standard way’ of doing something just doesn’t cut it and a need to customise it to make it work is needed. The same goes for visualisations that come as standard with Power BI tool, which for some may not provide the depth or complexity of visualisation that is needed in order to ‘bring data alive’. However by accessing the growing library of custom visualisations or even creating ones that meet a specific need is perhaps a way to find a competitive edge. Import Excel Data One of the recent improvements that was added was the ability to import data from Excel. It has a wizard for making it very straight forward so your Excel ‘Power User’s’ now have even greater functionality to make sense of the data. Power Q&A Have you wanted to be able to ask questions in your own language and have it answered? Now Power BI makes that very easy with the Dashboard Power Q&A and the underlying data models. You just start typing in your question and the data model provides the context and answer which can then be manipulated to suit your own visualisation needs.

What needs improvement?

Power BI is good with handling simple relationships between tables in a data model. But, if there are complex relationships between tables, that is, if they have more than one links between tables, Power BI might not handle them well. You need to create a data model carefully by having more unique fields so that Power BI does not confuse the relationships when it comes to complex relationships.


In most cases, you might not feel the need to configure and optimize visualizations in Power BI. But even if you do, Power BI does not provide many options to configure your visualizations as per your requirements. Thus, users have limited options for what they can change in visuals.


The user interface of Power BI is often found crowded and bulky by the users. It is in the sense that there are many icons of options that block the view of dashboard or report. Most users wish that the user interface or the report canvas was clearer with fewer icons and options. Also, creating scrolling dashboards is a native feature.


As we know, the expression language used to deal with data in Power BI is DAX. However, you can perform a lot of actions using the DAX formula in Power BI, it is still not the easiest language to work with. Sometimes the formulas you create work well in Power BI, sometimes they don’t. You can concatenate up to two elements but concatenating more than two elements needs nesting statements.


Power BI has a limit of ingesting data at a time which is approximately 2 GBs of data. If you wish to import and use data of even greater volumes, you need to extend your free version to a paid version of Power BI. Also, users have reported that Power BI takes a little more than usual time or even hangs while processing millions of rows and columns of data.


Usually, Power BI is the easiest to use BI tool if you are using it simply to import data and create reports. But Power BI is an entire suite having a lot of other interrelated tools. When the purpose of your use is more than just creating reports in Power BI Desktop, you need to learn and master several other tools like Gateways, Power BI Report Server, Power BI Services, etc.

For how long have I used the solution?

I have been using this solution for more than three years.

What do I think about the stability of the solution?

I am currently using it for my personal training, and I didn't find any stability issues, but when it comes to big data, there may be some sort of issues where the system might hang.

What do I think about the scalability of the solution?

In terms of adding more users, there shouldn't be any issues or limitations. Currently, I am using it for my personal use.

For very big companies with large-scale data and many rules, there would be speed issues with Power BI. Therefore, I don't recommend Power BI at this level. For such organizations, Tableau is the best solution. I have tried Tableau in many companies with many nodes, and I found no speed issues with Tableau. So, I won't recommend Power BI for organizations where 2,000 or 4,000 computers are connected, and there are multiple branches with data coming from different countries.

How are customer service and support?

I contacted them for an installation issue related to the RPA Power Automate Desktop. I had downloaded this software, and I was trying to use it with Office, but there were some installation issues. I contacted Microsoft's technical team, and they logged in to my computer and fixed the issue.

Their support is very nice. They called me and then remotely connected to my computer through Teams. They gave me very good support, and I am perfectly satisfied with them.

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

I can mentions main difference between Power BI and tableau which is as under. Advantages of Tableau Here, are pros/benefits of using Tableau BI: •Less cost of training •Very fast and easy to create visualizations •Good customer support •Data Interpreter Story-telling ability •Tableau offers a feature of visualization •It helps you to combine shape & clean the data for analysis. •It helps you to handle a large amount of data. •Uses scripting languages like R & Python to avoid performance for complex table calculations. •Allows users to create reports, dashboards, and stories using Tableau Desktop. Advantages of Power BI Here, are pros/benefits of Power BI •Offers pre-built dashboards and reports for SaaS Solutions •Provide real-time dashboard updates. •Secure and reliable connection to your data sources in the cloud or on-premises •Power BI offers quick deployment, hybrid configuration, and a secure environment. •Data exploration using natural language query. •Feature for dashboard visualization •New features frequently added that are great for excel users. •Extensive database connectivity capabilities Q&A feature publish to the web. •integration with both Python and R coding to use visualizations. •Power Query provides many options related to wrangling and clean the data. •Post publishing the data into Power BI web service can schedule refresh without manual intervention. •Power BI backed by the superpower of with artificial intelligence and machine learning. Disadvantages of Power BI Here, are cons/drawbacks of Power BI •Dashboards and reports only shared with users having the same email domains. •Power Bl will never mix imported data, which is accessed from real-time connections. •Power BI can't accept file size larger than 1 GB. •Dashboard never accept or pass user, account, or other entity parameters. Disadvantages of Tableau Here, are cons/drawbacks of Tableau •Relatively high cost •No change management or versioning •It is expensive, BI, when compared to other tools. •Importing custom visualization is a bit difficult. •Not offers easy methods for embedding reports to other applications. •Tableau is suitable only for a large organization which can pay for licensing cost. •The tableau does not offer support for artificial intelligence and machine learning. •There is integration with other Microsoft products like Power Apps , Dynamics 365, Office 365, and Microsoft Flow, which uses Single Sign-On (SSO).

How was the initial setup?

Its initial setup is very simple. There is no issue at all. If you have everything set up on your computer, it takes only 10 minutes.

In terms of maintenance, Power BI does not require any maintenance, but the database behind Power BI requires some sort of maintenance. Power BI is like a tap. It is just providing what is in the tank. For clean water, you just need to clean the tank at the back. To get good visualizations, you need to clean your database, tabling structure, and data modeling. If you are doing all data modeling in Power BI, then data modeling requires some sort of maintenance.

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

Power BI comes in three levels – Desktop, Pro, and Premium. The Desktop level is free for individual users. Pro – The Pro plan costs $9.99 per user, per month and includes a mobile app, the ability to publish and share reports, a 1 GB model size limit, eight data refreshes daily, the ability to connect to over 100 data sources, embedded APIs and controls, AI visuals, data security and encryption, metrics for content creation and publishing and up to 10 GB per user maximum storage. Pro is available for free for companies that have the Microsoft 365 E5 solution. Premium (per user) – Microsoft launched this new pricing strategy that costs $20 per user, per month. It includes all of the features of the Pro plan, plus paginated reports, a 100 GB model size limit, 48 data refreshes daily, advanced AI features, XMLA endpoint read/write connectivity, data flows, the ability to analyze data stored in Azure Data Lake Storage, application lifecycle management and up to 100 TB of maximum storage. Premium (per capacity) – This plan starts at $4,995 per month per dedicated cloud compute and storage resource. It includes all of the features of the Premium per user plan, plus on-premise reporting, a 400 GB model limit, multi-location deployment management, Bring Your Own Key (BYOK) and autoscale add-on.

Which other solutions did I evaluate?

No, I am diehard fan and accredited professional of Microsoft technologies, so I have no other thought.

What other advice do I have?

I will suggest below guidelines to Power BI users. Limit the number of visuals in dashboards and reports According to Microsoft's Optimization guide for Power BI, placing many visuals in a single report slows report performance. Limit widget visuals to eight per report page and grids to one per page. Limit pages 30 points (cards: 1, gauges: 2, charts: 3, maps: 3, grids: 5). Limit tiles to 10 per dashboard. To improve Power BI report performance, remove unnecessary interactions between visuals By default, all visuals on a report page can interact with one another. For optimal report performance, interactivity should be minimized. Reduce the number of queries fired at the back end and improve report performance by disabling unnecessary interactivity. Enable Row-Level Security (RLS) Row Level Security restricts user access to certain rows in a database depending on the characteristics (role) of the user executing a query. With RLS, Power BI only imports data the user is authorized to view. Combining Power BI roles with roles in the back end can result in substantial performance gains. Test all roles before rolling out to production. Use Microsoft AppSource certified custom visuals Power BI certified visuals are AppSource visuals that have passed rigorous quality testing. Microsoft verifies that certified custom visuals have robust, high-performance code. Certified custom visuals are the only custom visuals that can be viewed in Export to PowerPoint mode and email subscriptions. Use preview feature of hierarchy slicers instead of custom visual If you need to show hierarchy in slicers, enable the preview feature provided by the Power BI desktop instead of using of a custom visual. Provide data categorization for Power BI reports (HBI, MBI, LBI) High Business Impact (HBI) data requires users to get a policy exception to share the data externally. Low Business Impact (LBI) and Medium Business Impact (MBI) data do not require exceptions. By using Power BI data sensitivity labels, you raise user awareness about required security and how reports should be shared inside and outside the organization. Use on-premises data gateway instead of Personal Gateway Personal Gateway takes data and imports it into Power BI. Enterprise Gateway (on-premises data gateway) imports nothing, which is more efficient when working with large databases. Use different Power BI gateways for Live Connection and Scheduled Data Refresh If the same gateway is used for Scheduled Data Refresh and Live Connection, Live Connection performance will slow down when Scheduled Data Refresh is active. Avoid this issue by creating separate gateways for Live Connection and Scheduled Data Refresh. Test custom visual performance on reports to ensure fast report load time; use an alternative visual if the chosen visual performs poorly Uncertified custom visuals are generally not tested by the Power BI team. Custom visuals can perform poorly when handling large datasets or complex aggregations. If a custom visual performs poorly, consider replacing it with a different visual. Limit complicated complex measures and aggregations in data models Push calculated columns and measures to the source where possible. The closer they are to the source, the higher the likelihood of improved performance. Create calculated measures instead of calculated columns. Use star schema to design data models. Use slicers sparingly Slicers are a great way of allowing users to navigate data, but they come at a performance cost. Each slicer generates two queries: one gets the data, and the other fetches selection details. Creating too many slicers negatively impacts performance. To evaluate which slicers are infrequently used, use the Filter pane and remove unnecessary slicers. Ensure the Power BI report and data source are in the same region With the tenant and data source in the same region, you can reduce network latency. The results are faster data transfer and faster query execution. Import only necessary fields and tables instead of entire datasets Ensure the model is as narrow and lean as possible. Power BI works on columnar indexes; longer and leaner tables are preferred. Ensure the cache update frequency aligns with the data source refresh frequency Cache update frequency should be set at similar intervals to data source refresh frequency. By default, the Power BI cache update frequency is set to one hour. If, for example, your data set refreshes only once per day, you should update the cache frequency accordingly. Use white or light background colors For users distributing printed reports, white or light backgrounds are printer friendly. Shorten numbers Don’t exceed three or four numerals when displaying numbers. Display measures to one or two numerals left of the decimal point and scale for thousands or millions. Use Report Tooltip pages to provide more context for the highlighted measure Report tooltips are a great way of sharing additional information on the metric. Use limited visuals in Report Tooltip. Ensure you select Tooltip field carefully (categorical or measure). Use templates (.PBIT files) to speed up and standardize report development instead of starting with an empty .PBIX Templates can be saved with custom color palettes and themes pre-incorporated. Templates ensure corporate branding is pre-applied to all pages. Templates ensure connections to commonly used data sources are already in place. Templates create commonly used DAX measures. Source: LinkedIn Use names that are meaningful to your business users or intended audience Power BI provides the ability to give aliases to report objects. Avoid ambiguity when naming columns and measures. Consider hiding unused columns in the data model. Source: LinkedIn Reduce queries Reduce the number of queries sent by Power BI using the settings for Slicers and Filters.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user

Pra mim, deve ser ultilizado com recursos um pouco mais simples para atender outros publicos, facilitando os usuarios a terem conhecimento sobre a plataforma.

Ankita Mandowara - PeerSpot reviewer
Senior Software Engineer at Ace Infoway Pvt. Ltd
Real User
Top 5
Easy to use, but it needs to be made available to users for free
Pros and Cons
  • "The advantages of Microsoft Power BI stem from the fact that it is really easy to use. The drag and drop facilities provided by the product are good."
  • "From any improvement perspective, I want the product to be made available to users free of cost...The stability and scalability of the product can be better."

What is our primary use case?

I use the solution in my company for data analysis and visualization.

What is most valuable?

The advantages of Microsoft Power BI stem from the fact that it is really easy to use. The drag and drop facilities provided by the product are good.

What needs improvement?

I only face problems when I want the product for free to help prepare for some of the demos for my company.

From any improvement perspective, I want the product to be made available to users free of cost. The product should not require any subscriptions.

The stability and scalability of the product can be better.

For how long have I used the solution?

I have been using Microsoft Power BI for six months. My company is a customer of the product.

What do I think about the stability of the solution?

Stability-wise, I rate the solution a seven out of ten.

What do I think about the scalability of the solution?

Scalability-wise, I rate the solution a seven out of ten.

How are customer service and support?

I don't have any experience with the solution's technical support. I rate the technical support a five out of ten.

How would you rate customer service and support?

Neutral

How was the initial setup?

The product's initial setup phase was easy.

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

I rate the product price an eight on a scale of one to ten, where one is low price and ten is high price.

What other advice do I have?

The product improved my company's decision-making project when I was involved in a project where I had to do an analysis involving LinkedIn and other social media accounts.

The product's maintenance phase is easy.

My company can share and manage Microsoft Power BI across different teams in the company since we have only opted for the subscription for a single person. In my company, we do exchange web URLs, and it helps us exchange reports with different teams.

My experience with the real-time dashboard updates of the product has been good.

I rate the overall tool a seven out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1576593 - PeerSpot reviewer
Data Scientist at a energy/utilities company with 501-1,000 employees
Real User
Provides good and logical visibility; difficult to easily share the dashboard with external people
Pros and Cons
  • "It provides good visibility."
  • "Things can slow down if you create too many pages."

What is our primary use case?

We are power industry consultants and we collect line operation data from power plants, preprocess it and then put it into some visualization software such as Tabula or Power BI. We then generate a regular test report for our customers who are power plant operators. 

What is most valuable?

It provides good visibility to the customer. They can see everything that's going on in a logical and user-friendly way. 

What needs improvement?

If you create too many pages, things can get heavy and slow down significantly. Once you create the dashboard, the data is updated at certain time intervals. I'd like to see more flexibility around those time options. It's difficult to easily share the dashboard with people outside the organization. 

For how long have I used the solution?

I've used this solution for two years. 

How are customer service and support?

The Microsoft support is not very good. When issues arise, I use Google or the user discussion boards. 

How would you rate customer service and support?

Neutral

How was the initial setup?

The initial setup is straightforward, it's just a matter of downloading the software from Microsoft and installing it. 

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

The solution is very affordable. 

Which other solutions did I evaluate?

The big difference between Tableau and Microsoft BI is the price tag which is much higher for Tableau. Tableau also provides a server for web publishing. It means you can easily share the visualization with people outside your company. In that sense, Power BI is more difficult. I also think Tableau may be more secure. 

What other advice do I have?

I would recommend this solution if you're a smaller organization. If you have massive data, like a corporation, then Tableau is probably the product to use. 
I rate this solution six out of 10. 

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
IT Cybersecurity and Compliance Coordinator at Plaenge
Real User
Good visibility, fast track support, reliable, and easy to install
Pros and Cons
  • "One of the most valuable aspects of this tool is its ease of use and the ability to easily share information with others."
  • "There is room for improvement in terms of pricing for the solution."

How has it helped my organization?

To gain insights into our sales and financial aspects, we use the Power BI solution, which provides us with valuable information and analytics.

What is most valuable?

One of the most valuable aspects of this tool is its ease of use and the ability to easily share information with others.

What needs improvement?

There is room for improvement in terms of pricing for the solution.

For how long have I used the solution?

We use Microsoft BI in our organization. I have been working with it for two years.

We have implemented the Power BI Pro solution in our organization.

What do I think about the stability of the solution?

I would rate the stability a nine out of ten.

What do I think about the scalability of the solution?

I would rate the scalability a nine out of ten.

We have plans to increase our usage in the future.

How are customer service and support?

I would rate the technical support a nine out of ten.

We use fast track support and it is very good.

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

I have been acquainted with SolarCloud for three months.

I haven't worked directly with the solution, but I downloaded the eBook to learn more about it.

How was the initial setup?

Due to our extensive experience with the tool, the initial setup was straightforward and uncomplicated.

What was our ROI?

We have seen a return on investment.

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

The pricing for the solution is relatively higher compared to other alternatives.

What other advice do I have?

I am a cybersecurity analyst.

Knowing the numbers and having comprehensive insights are important for our organization. It holds significant importance for various teams, including finance and other departments, to make informed decisions and drive overall growth and success.

I would rate Microsoft BI a ten out of ten.

Which deployment model are you using for this solution?

Hybrid Cloud
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: August 2025
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.