We performed a comparison between Microsoft Power BI and QlikView based on real PeerSpot user reviews.
Find out in this report how the two Reporting solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The solution is quite scalable."
"Ease of development and maintenance."
"Being able to transfer data with the Power Query feature is great for teaching with about one to two hundred rows of data. I am also able to see the relationship between multiple tables and create various sheets and dashboards."
"My favorite feature is the power query editor, where it can do the data transformations."
"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's pretty easy to set up the product."
"Everything that's in M Query and DAX is the heart of Power BI because with these tools you can make up for a lot of other missing features."
"We are able to collaborate on things and get insightful data visualizations."
"It is useful to use a tool like this to have a view of data at a point in time. You can extract and create little data sets that you can store, and then over time, you can have a view for tracking changes. Especially when you work with a relational database or a database that's a production database, the data is dynamic, but if you use QlikView, you can take a snapshot of different datasets. In your own time, you can then get insights and report, build, analyze, and draw whatever you need from the data, which is quite useful."
"Scripting as per a customer's need, which is a pretty cool feature and not available in other tools."
"It's pretty easy to deploy."
"The initial setup is not very complex."
"We use QlikView for its cost-effectiveness and ease of integration with databases."
"I had the option to prepare data myself instead of always having to depend on the data team."
"It enables us to configure various elements, such as dashboard settings, including factors like color schemes and other customization parameters."
"You can do a lot of things on the back end which are not possible in the other solutions on the market."
"When you go to the cloud, its licensing is not intuitive. It is a little bit complex. When you have to purchase a new license, it is difficult to understand on their website what exactly you need to pay and how you can group. It is something that is applicable to all Microsoft products. They're not always so simple and clear when it comes to licensing. Their support can also be better in terms of explaining how they resolved an issue and what steps they took to resolve it. They are able to resolve the issue, but they can be better at explaining the approach they took to resolve the issue. It could have something in the direction of machine learning. It can have some kind of integration with machine learning where you can ask for some reports with natural language."
"More connections with other systems should be added, which would allow for other integrations."
"It could have more of a hold on big data. Manipulating big data on this solution complicates things. This needs to be improved."
"They asked you to pay if you want to synchronize more than eight times, you would have to go to a Power BI enterprise license, which is much more costly."
"I would like them to provide a license that just allows us to see dashboards. What I don't like about this solution is that in order to just watch a dashboard, you need a license. Currently, you need to purchase a full license of Power BI Pro just to see something, which is not attractive. If you have a license, you can see a shared dashboard, but you can also build a dashboard or you can collaborate with other people. However, if you only want to see a dashboard, there is no license for that. I only want to see the dashboard, and I don't want to do anything more than watching the information on the dashboard. There is no license that allows you to see a shared dashboard. This is one of the areas of opportunity because I would like a lot of people to be able to see a shared dashboard, not to interact with it or to collaborate online with it. I would like to see more compatibility with non-Microsoft data sources. Given the fact that everything is related to Microsoft Azure and all services available on Microsoft Azure, I see that they're building more connections to Microsoft Azure services instead of other non-Microsoft services. I understand the strategy, but it would be good to have more compatibility with non-Microsoft data sources."
"I have a little problem with Synapse Analytics because it's very new. It's a product that has many capabilities, but it is not very well developed. I have to see the list of permissions from one object. I can't do this in Synapse. I have to search on the web for a solution because I don't have the tool for it."
"My main complaint is that the error messages need to be made more clear. Currently, they are either too generic or outright misleading, and finding the real problem is like searching for a needle in a haystack."
"It should be easier to use when there are multiple system sources."
"The user interface is old."
"Installation and deployment could be made easier and quicker."
"More/newer visualisation components need to be added."
"Although Qliktech's road map clearly states that QlikView has a long way to go, most of the R&D effort seems to be benefiting Qlik Sense."
"Error handling."
"Needs improvement with UI transparency."
"They could improve the speed."
"The user interface and ease of use takes a bit of a learning curve to pick up."
Microsoft Power BI is ranked 1st in Reporting with 297 reviews while QlikView is ranked 5th in Reporting with 158 reviews. Microsoft Power BI is rated 8.0, while QlikView is rated 8.2. The top reviewer of Microsoft Power BI writes "A complete ecosystem with an builtin ETL tool, good integrations with python and R, and support of DAX and Power Query (M languages)". On the other hand, the top reviewer of QlikView writes "Useful for data visualization and business intelligence". Microsoft Power BI is most compared with Tableau, Amazon QuickSight, KNIME, Domo and Oracle OBIEE, whereas QlikView is most compared with Tableau, Amazon QuickSight, SQL Server, TIBCO Spotfire and IBM Cognos. See our Microsoft Power BI vs. QlikView report.
See our list of best Reporting vendors.
We monitor all Reporting reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.