Microsoft Power BI Reviews

In January, I successfully published my application on AppSource, specifically targeting retail customers. Recently, I received positive feedback from a customer, which was truly gratifying. It seems that my application is Microsoft's preferred choice as it effectively addresses the majority of customer requirements and is tailored to their specific requests. 

Apart from retail applications, I have also developed solutions for BigChange, an organization dedicated to driving significant changes. Additionally, I have worked on creating reports focusing on production efficiency within my company. These reports have been well-received and have provided valuable insights. Lastly, I have recently worked on an application that involves managing IT resources and has developed a multi-dimensional model including SSIS and Power BI.

For the last project, I worked on creating data flows and implementing incremental refresh functionality. However, there was an issue we encountered regarding the date field in the tables. The existing portal dates were incorrect as they did not reflect changes in the records. To address this, we collaborated with the developers to introduce an additional column that accurately captures modified data in the system. This improvement has proven to be significant, and it can be implemented using the pro license, rather than relying on the premium license, as the premium license covers different aspects.

The Pro license offers great features such as incremental refreshing, which is highly beneficial. While it doesn't include direct query capabilities, I believe that many customers don't actually require direct query functionality. 

Currently, the developers in my company are busy adding a column in the API as part of our transition to BC Start. Our intention is to gradually migrate our customers to SQL Server, and that's why we are using the app.

In a simplified manner, when working on-site, you cannot directly connect to the regular table without using APIs. That's why the APIs need to be modified to include an additional column, making it suitable for incremental refreshing. Apologies for any disruption caused, but I hope this explanation clarifies the situation.

They find Power BI's data pull mechanism to be sufficient and cost-effective, especially considering the stability it provides. In comparison with other solutions, Power BI stands out as a fantastic choice. Therefore, I would definitely recommend sticking with the Pro license.

I believe there is room for improvement in terms of authentication and certain functionalities in Power BI. For instance, adjusting the width of columns is not easily done, as there is only an option to enable or disable automatic adjustment. 

This can be a significant drawback for clients who desire more flexibility.

Additionally, changing styles and formatting options for numbers require external tools, which can be inconvenient and time-consuming. Ideally, Power BI should incorporate these features within its platform to enhance user experience and eliminate the need for external tools.

I understand your frustration with the lack of automation and dynamic features in Power BI, particularly regarding the assignment of dynamic titles and content titles. While there are some options available for creating dynamic titles, they may not fully meet your specific requirements. It would be ideal to have more flexibility in manually assigning the desired typography for each call and dynamically setting content titles. Although it is possible to find workarounds for these limitations, I believe Microsoft will likely address these issues in future updates to improve the user experience. Despite these shortcomings, Power BI remains a powerful and highly capable application, and I would rate it an eight out of ten.

I have a strong belief that within the next couple of years, or even sooner, significant advancements will be made in Power BI. These advancements will make it even more powerful and I am confident it will become truly exceptional. I have complete faith in the future development and potential of this platform.

I have been working with Microsoft BI since the start of 2020.

I am working with the latest version.

Microsoft BI is very stable.

Microsoft BI offers scalability, particularly with the availability of premium capacity. With premium capacity, whether it's per user or a dedicated resource, Microsoft BI can effectively handle increased data volumes and accommodate growing user needs. 

Microsoft BI offers scalability in specific areas, but it is important to note that scalability options are limited to certain aspects and may come at a higher cost. For instance, the premium package, which starts at around $5,000 or more, provides enhanced scalability features. However, if you opt for the per-user licensing model, the scalability may be constrained as it is tied to the number of licensed users. Therefore, in terms of scalability, the per-user option may have limitations compared to other packages.

I wrote to Chris Web, and he replied to me immediately. He is the principal program manager at Microsoft.

I have him I have him working And, usually, I don't contact them, only when it is something serious. top expert and experts, and they reply, you know, has been one for us. It's great

In my professional experience, I have primarily worked with AS (Analysis Services), Power BI, and SSIS (SQL Server Integration Services).

Last week, I worked on creating SSRS (SQL Server Reporting Services) reports and integrated them with SSAS (SQL Server Analysis Services). Additionally, I hold a Microsoft certification in this field.

The initial setup is straightforward. It is very easy to set up. it is very intuitive.

Perhaps it's because of my experience and expertise in the field that I approach things with caution. I don't take things for granted. Just because I obtain a certain result doesn't automatically mean it's correct, as there may be errors that are not displayed.

It's important to carefully check the measurements and ensure their accuracy, especially for beginners who may not be familiar with these nuances.

Maintaining the system is not difficult due to the availability of the admin platform. When it comes to permissions and access, it becomes straightforward as long as the customer's requirements are clear. 

You can easily define the level of access they need, whether it's building, reviewing, sharing, or restricting data access for online viewing. Depending on their specific needs, setting up gateways and configuring other settings is also simple. 

It's important to have a clear understanding of their security requirements and engage in discussions with the customer to determine the best approach. 

Often, customers may not be fully aware of what they want to achieve, and it's our job to help them identify their needs.

Especially for clients, it's important to understand that achieving the desired outcome is not as simple as just completing the task and generating the report.

There are several factors and considerations that come into play. Careful attention needs to be given to the creation process by different stakeholders if you truly want to achieve an exceptional result. 

Even small changes, such as removing certain elements from the selection or adjusting formatting, can have a significant impact on the report. Users may perceive the tool as being the same regardless of these details, but the difference between a subpar report and a high-quality one lies in the expertise and knowledge of the creator.

There are various options available for creating reports, particularly focusing on online reports. However, the foundation of the process lies in Power BI Desktop. Whatever we develop in Power BI Desktop can be published and accessed through a unified platform and tool. 

Data flows enable us to make necessary modifications, similar to working with Power Query and related functionalities. Personally, I find working with Power BI Desktop easier due to its comprehensive features and user-friendly interface.

You can gather data from various sources, including data flows, RBI databases, and SharePoint, among others, and then create and publish your report. While you do have the option to connect to online sources directly, I personally find that working with local data feels faster, at least for now.

Microsoft BI is considered to be competitively priced when compared to other similar solutions in the market.

I haven't had the opportunity to work with other tools as I found Power BI to be excellent. No one has specifically asked me to explore other tools.

However, I did purchase some tools on my own for personal learning purposes, particularly for tabular data. I may consider exploring other tools after June 15th, once I have completed my Microsoft exam DP-500 for Synapse.

Power BI is a complex tool that should not be taken for granted.

Its capabilities and functionalities are multi-layered, and the more you delve into it, the more you realize how much there is to learn. 

It can be both challenging and fun to explore the different features and unlock the full potential of Power BI.

As a BI developer, I joined the company without prior experience in BI. Since December 2021, I have been working on establishing a BI deployment in collaboration with a partner. My main focus is to create and enhance internal and external applications for app stores. Currently, my task primarily involves developing a new deployment strategy.

I would rate Microsoft BI an eight out of ten.

There are several different use cases. The most basic use case would be just to be able to share data from a database or a data repository. That's the most basic use case.

Microsoft Power BI is a visualization tool, is a BI tool. There are more than 1,000 use cases that you could use. There are countless use cases for which a BI tool or visualization tool could be used for.

The simplest use case is where a colleague in an organization who does not have any coding skills or does not have any technology background wants to be able to look at some data from a database or a repository of data. He or she could use Power PI just to be able to connect to that system and just take a look at or peek into that database. It is as simple as that.

Over the last six years, Microsoft Power BI has evolved, matured, has brought in a lot of new features. Six years back, when I first started using Microsoft Power BI, it was just one of the tools among the crowd of tools that I had access to and may not have been that interesting, at that point in time. It was fairly rudimentary and fairly basic in terms of its feature capabilities. However, in the last six years, Microsoft has put a lot of focus and effort into developing it further, and has, on a regular incremental basis, started deploying and enabling capabilities and features, which now makes Microsoft Power BI one of the leading BI tools in the industry.

We realized the benefits very quickly. In 30 minutes, a company can begin to realize the benefits.

In the most basic use case, which is for a user to be able to just access a data which he or she normally would not have been able to himself or herself, since they don't have SQL query knowledge, or they don't know how to access, log into a SQL Server or a database. They can do that using Power BI within half an hour or less.

Like any typical BI visualization tool, Microsoft has several features. The most interesting feature of Microsoft Power BI is that it's very user-friendly.

It is a cloud-based BI tool even though it does come with a desktop client. The ability for a very beginner, basic user to get started with Power BI is very easy. Even if you don't have Microsoft licenses and just want to use a tool for analyzing data, without having to share it with others, you can do that with Microsoft Power BI.

I'm comparing this with other existing and newcomer BI tools. The look and feel of the tool has, only like a month back, undergone a major change. If not, for the last five years at least, last four years at least, the look and feel have been very, very similar all the time. 

It did not change much in the last four years. Barring a lot of functionalities and capabilities being added, it did not change much. The look and feel were pretty much the same. However, about a month back, the latest release of Power BI, they made some further, drastic changes to the way the buttons and the panels are set up. That said, they can do more. There are still better UI designs they can go through. I'm assuming they are focusing more on capabilities rather than look-and-feel designs.

I've used the solution for six years now. 

The solution is quite stable and we have not had any, not come across significant bugs, so far. We've only come across some features which are missing or could have been improved, like certain types of charts that were missing in the past, which are being added. Some of the advanced charts are available as a paid service from third-party partners and not available out-of-the-box. There are very unique features or some very specific capabilities that were missing or are still missing. We could always manage it by bringing in a partner to create an add-on or something like that.

The solution is very scalable and we do plan to increase usage. 

We haven't opted for technical support yet as we have a few other tools which are also being used by the organization, in the new organization that I'm in, right now. Power BI was being offered to colleagues to use on a self-service basis. There were communities and subject matter experts within the organization who had offered their services to the wider organization to come and ask questions. It was basically community-based support, I would say, within the organization. 

Also, Microsoft offers free community-based support for Power BI and proactive support is simply paid. It's paid service from Microsoft and other partners, so we have not opted for that yet, something we will look into once it comes to that point. Yet, it's a fairly mature product. We don't think there would be issues with the platform. The issues would be more to do with how to use the platform, or how to use the platform in conjunction with other systems, other software, et cetera, which is more specific to our organization rather than something the vendor has to support us with.

You do get your questions answered eventually, however, you have to wait maybe one or two days to get the questions answered.

Positive

I have used more than ten to 15 different types of software in the past 20 years.

I have used Tableau and I have used Qlik Sense. These two are, I would say, the top two leading platforms. We switched completely to Power BI, however, we started using Power BI more, alongside Tableau and Qlik Sense. The organization where I used to work previously had the commercial ability to acquire multiple software, depending on use cases, or depending on business requirements, or needs. In the previous organization, the organization was using one particular platform, then they decided to bring in a second platform, then they decided to bring in the third platform. As part of that mix-and-match scenario, we ended up using Qlik Sense and Tableau. And then we also started, in parallel, using Power BI, which then started to get better feedback and reviews, in general, so we ended up using it more and more.

It comes bundled with Office 365. Office 365 is a SaaS-based office suite. Anything that you build on your desktop or Power BI, you can publish into the Office 365 cloud environment. It's relatively easy to get everything up and running. 

It's as simple as taking your credit card and buying an Office 365 license and configuring the AD group and you can be up and running. Of course, depending on how secure and structured you want to make your entire setup, it can take a few months, sometimes, with the full rollout to happen. 

A very basic pilot rollout can be done in a matter of a few weeks.

For the actual deployment and configuration, we just needed five people, and five resources working between six to 12 months. Some were required only for six months. Some are still continuing as part of further enhancements as some of the resources are being retained from a training and onboarding purpose so that they can do a training of the wider organization, and colleagues in the organization, show them how to use Office 365, and get trained on that. The actual development itself took less than two or three months.

In terms of maintenance, there are regular patch updates that get pushed from Microsoft. The backend IT support team needs to ensure all the patches are tested before they're deployed in production, for all the users to use.

Microsoft usually sells through a partner, most of these licenses, and Microsoft also usually recommends a partner. In our case, we did an RFP to bring in the subject matter experts, partners who are certified on Microsoft platforms.

We had a system integrator who came in and helped us deploy and roll out Microsoft 365. As part of that, as I mentioned, we got Microsoft Power BI. 

We are now thinking if we should switch on all the other capabilities of Microsoft Power BI or not.

We have noted an ROI, however, it varies from use case to use case.

There are some use cases in which if you deliver it, the cost savings or the revenue generated from that, or the benefits from that one single use case will cover the entire cost of all 65 licenses, for the entire year.

Then there are use cases, in which you'll have to wait for a few years or months before a company will actually see some benefit being derived.

They have made the desktop client free of cost, which is also what Qlik Sense is. The Qlik Sense Desktop is free of cost. Tableau, the web version of Tableau online, there's a trial period you can use it for. Microsoft also has made Power BI available as a free add-on, or a free complimentary add-on alongside Office 365 for corporate users. This means even if the organization does not want to use Power BI, if they're using Qlik Sense, Tableau, Looker, ThoughtSpot, Domo, or the other tools, Power BI will still be available to them when they're using Microsoft Office.

While it comes bundled with Office, you don't have to buy any additional licenses, just for building and publishing. That said, the moment you want to start sharing your reports, your dashboards, and your analysis with others, that is the point where you need to then start paying for additional capabilities or plans.

I've always been part of different transformation programs where we were required to evaluate a BI tool, to meet the business requirements. Usually, Power BI ends up coming in the short list of products from a BI perspective, from a BI reporting perspective, apart from sometimes Tableau, and Qlik Sense. Sometimes, we also come across ThoughtSpot, Sisense, and Domo. These are some of the other tools which we have also, sometimes, shortlisted.

The differences have become very, very minimal between solutions. There are very few, minor differences between different tools. About four or five years back, there used to be drastic capability gaps between the different tools. Four or five years back, Tableau was the most mature, followed by Qlik Sense, followed by MicroStrategy, followed by a few other tools like SAP Analytics, or a few others. Today, Power BI is alongside Tableau, and Qlik Sense is in the top three. That's based on my experience of having worked on all these three platforms. Tableau, among the three, has the best UI, user interface. Qlik has the best performance, in terms of building complex data models. Power BI, however, is the easiest and most fun to use when it comes to getting somebody to use the tool from scratch. 

There are a few other benefits and strengths. Qlik Sense and Power BI, both come with built-in ETL which is data integration capabilities. They have very mature data integration capabilities, as compared to Tableau, whereas Tableau has very basic integration capabilities. You need to buy another ETL product for it to be able to do a similar level of data transformation as Qlik Sense, or Power BI.

We are a customer and may also be a Microsoft partner, as we are a telecom. 

I'd rate the solution nine out of ten.

Microsoft Power BI is an easy tool for data analysis. It's easier to get the data from different data sources and then create a visual representation. Using the tool comes easily and naturally to people proficient with Excel. You need to have an understanding of data modeling and how the data works. Once you work with Power Pivot, I think Power BI will be a better upgrade than other tools in the market.

There are some issues with Microsoft Power BI's integration with OAC because it's currently in the beta phase. We face multiple issues, and the connection drops off multiple times while integrating Microsoft Power BI with OAC and pulling in the data. The solution's integration capabilities have created some issues for us, especially while retrieving data.

I have been using Microsoft Power BI for over seven years.

The solution's technical support has not been very helpful. I have solved my issues by myself and found a workaround for it.

Neutral

I have worked with multiple data visualization tools, such as SAP One and SAP BusinessObjects, where you had different tools for data visualization. I think each tool has its own unique capabilities. The biggest advantage of Microsoft Power BI is its integration with Excel and how it is an upgraded version of Excel. We all know how Excel is used in the market, so Power BI has a strong advantage over its competitors.

I use the solution for myself, and I recommend it to my customers. I would recommend the solution to other users.

The selection of the visualization tool clearly depends on the data sources. I would recommend Microsoft Power BI if I worked for Microsoft. Otherwise, I would recommend other better tools available in the market. It completely depends on the data source and the data volume. I would not recommend Microsoft Power BI if the data volume is very high because it will tend to freeze your report.

Overall, I rate the solution an eight out of ten.

We mostly use Microsoft Power BI for reporting. We are going to build some solutions. We are going to deploy the scripts from Intune so that it can pull some data, which we can aggregate and show the projections on Power BI.

I really like the solution's integration part. You can integrate Microsoft Power BI with various other solutions like Intune. You can push the Intune data warehouse to Power BI. I really like the custom-built solutions that are available in Power BI.

I really wanted to send the inventory data to Power BI. I don't know whether the feature is available because I'm working on it and still need to look into it. The solution should increase the API functionality so that we can use Microsoft Power BI for other purposes and aggregate things.

I recently used Microsoft Power BI reporting for Windows Update. I wanted to understand where the reporting data came from, but I couldn't find it. It could be because I had fewer privileges. It would be good to know the data source for the solution's reporting part.

I have been using Microsoft Power BI for the past six months.

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

Microsoft Power BI can be used by all company sizes because it's all about aggregating and visualizing data. Any organization needs to have a broader perspective on what is happening. It could be useful for both large and small applications. All ranges of companies can utilize Power BI.

I rate the solution a nine out of ten for scalability.

The support engineers are not ready to schedule the calls or understand the issues and are very eager to close the cases. I have previously worked at Microsoft as a support engineer. I know they may have workloads and may need to handle multiple cases in a day.

However, I'm not finding even the basic courtesy of handling the issues from the engineers' perspective. Except for a few, many engineers are not willing to help the customers. They focus more on their limitations, saying that they don't deal with such issues or that they are out of their scope.

I rate the solution’s technical support a six to seven out of ten.

Neutral

Informatica is a competitor to Microsoft Power BI. However, Microsoft Power BI is very easy to use, and even a nontechnical person can implement it. Other solutions are a bit complicated when compared to Microsoft Power BI.

The solution’s initial setup is very simple. The solution's deployment takes less than 15 to 30 minutes.

Microsoft Power BI is deployed on the cloud in our organization. I would recommend the solution to other users.

Overall, I rate the solution a nine out of ten.

We use it for data modeling, joining data from different data sources, and visualizing dashboards and reports for end-users and business process owners in the company.

The various different ETL tools within it and the ability to have different data refreshes and scheduled refreshes [real-time data refresh capabilities] have most significantly improved the data analysis processes.

Power BI is easy to adopt. It's quite easy to roll out into the business for end-users, and the functionality for modeling and such is quite extensive for the data department.

It has connected to quite a few different things. We use the Microsoft stack, so it's fairly connected.

Better structure and stability in terms of licensing and capacity. Microsoft is changing things with Microsoft Fabric and how it's impacting different functionality for premium users, capacity users, and pro users. So, that's where licensing could be improved.

I have been using it since it came out. It's been many years.

I would rate the stability a seven out of ten.  

Sometimes, updates can cause data refresh issues.

I would rate the scalability an eight out of ten. 

There are 100 end users in my organization. We use it daily. 

It takes a while to get the issue described, looked into, and resolved. It's a lot of troubleshooting and "try this, try that," rather than acknowledging that they've had this issue elsewhere. There doesn't seem to be a joined-up approach for people experiencing similar issues and how to resolve them.

Neutral

I have used various different modeling tools and BI tools. 

We used Tableau before, and general Excel modeling, etc.

I would rate my experience with the initial setup an eight out of ten, with one being difficult and ten being easy. 

It's cloud-based.

Initially, it's quite straightforward. It depends on how you want it set up, like with gateway refreshes, etc.

Just more visibility for end-users to use and interact with data.

I would rate the pricing an eight out of ten, where one is cheap and ten is expensive.

Overall, I would rate it an eight out of ten. 

I developed a product based on Power BI. I intensely use it. 

I also use it to generate reports and monthly management reports. It's connected to the production database with connectors. It's not so big data, but it's for medium-sized datasets.

It's easy to develop custom solutions. The DAX scripting solution of Power BI is easy to use and covers a lot of needs. 

It's user-friendly. It also has the capacity to connect to a variety of data sources without any other solution – especially within the Microsoft environment- which is very easy.

For us, it's difficult to manage business data and visualize and model it without Power BI or a similar tool. Although, I am more comfortable using Power BI than any other tool. Data modeling is one of the most important features of Power BI because you can model almost anything. For me, it is very helpful. 

I haven't personally faced challenges with Power BI, but it might be challenging when it comes to big data usage. I haven't had a real challenge yet - maybe it could become challenging due to a lack of information or skills to use Power BI at a more advanced level.

So, the product could be complex for inexperienced users. It's very complex and you need to keep up with the updates. Otherwise, you can miss a lot of nice features that can be useful in your daily work.

I'm looking for something that can make it much easier to incorporate Power BI visuals or dashboards into, let's say, Power Apps – custom Power Apps or anything like that. 

The most important thing would be to seamlessly embed reports in applications. For example, to have buttons that can be navigated through multiple solutions – from Power Apps to Power BI to SharePoint – via links or something like that. 

If this transition is more natural (so users don't notice they're moving between solutions), it will be very helpful in developing complex solutions without sophisticated workarounds or lots of code. 

Staying within the low-code area, there's a lot of potential for interesting things. This is my main focus – developing low-code solutions that integrate with Power BI.

I work with Microsoft's entire suite of products. 

I have been using Power BI for more than five years. 

I haven't had major issues because my usage is at a medium level, not a high level. I haven't personally interacted with Microsoft support. But, there seems to be a lot of information and people using this solution, and it's easy to escalate problems within your company. You can learn a lot of things quickly using resources like ChatGPT or Microsoft's own solutions, which are very helpful within the Microsoft ecosystem.

I used MicroStrategy. It's very nice, and similar, but a bit more difficult to connect to other systems. You need more technical skills. With Power BI, those connections are easier. I am not obliged to learn a lot of technical aspects.

For me, Power BI is a very good option. If you're in the Microsoft ecosystem, working with people who use Microsoft solutions, Power BI makes sense. It might be a bit more difficult if you're in a different ecosystem – companies tend to promote their own technologies for upsells and cross-sells. It's a sales thing.

Price is the best feature of Power BI! You get a lot of value for the price. If you know how to use it, it's a great BI solution for your money. 

A complete solution license is no more than fifty euros per month – that's not expensive at all. Even thirty euros per month is enough to have Power BI, Power Apps, SharePoint solutions, and things like that. Very, very cheap.

Overall, I would rate the solution a nine out of ten.

I would definitely recommend using this solution. Power BI offers very good value for money. You do need some skills, but not necessarily deep technical ones. 

It's more important to understand the business context and how to design effective reports in order to put Power BI and connected solutions from the Power Platform to best use. 

My view is that we often overemphasize the technology and miss the true asset: the value that Power BI and the others bring to the business.

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.

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.

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.

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

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.

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.

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.

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).

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.

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.

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

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.

During my internship, I used Microsoft Power BI to create reports for a project we were working on. I also made a dashboard to help a company grow its business.

What I liked most about the tool is that we can use text queries to create projects and modify columns according to our needs. There are hundreds of YouTube courses on how to use it. 

I found data cleaning in the solution to be quite difficult. If I could add a feature, I'd include Excel's Flash Fill function. This allows you to set a formula for one row and column and automatically apply it to thousands of rows, making data sorting much easier.

I found the tool to be a stable product. One of my favorite features is connecting a SQL database to the tool to generate real-time reports. I was part of a group of 80+ students, but only five of us, including me, were offered internships and could use Microsoft Power BI.

I haven't contacted the solution's support yet. 

Installing Power BI is easy—there are free and paid versions available. I used the free version, which you can download from the Microsoft Store and install, similar to installing an app on your phone.

I used the tool's free version. 

I'd recommend Microsoft Power BI for report generation - it's great software. I rate it a nine out of ten.