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."It is very well integrated with other Microsoft products, including PowerApps and Excel, as well as Access, so it fits well into our workflow."
"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."
"The solution is very intuitive, you do not need to have too much programming knowledge to use it. Advanced Excel users can use it very easily."
"Like all Microsoft products, it is very easy to set up initially."
"We've used Microsoft BI for the general use cases around reporting and dashboarding."
"We have found that the reporting and publishing are great."
"It has provided customer purchase patterns and great visualization."
"I like the downloadable visualizations a lot. I think that they give the user a very nice starting point in creating awesome dashboards, with the right way to tell their data story."
"The most valuable feature of QlikView is the integration with other third-party tools."
"The scalability is there."
"It excels in supporting database connections and various database types."
"Data transforming with scripting, and the associative model that lets users browse data in an easy way, are the most valuable features."
"We can scale it if we need to."
"It is a stable product."
"The search feature: ability to see the related data."
"The integration with Salesforce has helped us gain access to crucial sales data in real-time."
"Microsoft BI could improve by allowing large-size data sources. We have large data sources, and we have problems loading them in Microsoft BI."
"The solution is somewhat costly in comparison with MSBI tools."
"Better mapping capabilities and easier administration access would be beneficial, especially for understanding who has viewed reports."
"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."
"It's not really complicated, but I didn't find the things I was looking for. The ones I used to work with within Dash are more open, and there are more choices. But with Power BI, there are only limited types of plots that I can use. For example, when I wanted to put the plots in Power BI, there was no extendable space. You have a limited page where you can place a maximum of three plots in that, and you can't do more than that on a single page. You have to create a new page, a different page for that. That made it a bit annoying, and the filtering part is limited, with basic functions. If you want to make custom filtering or custom functions, you can't do that."
"Most of the dashboarding tools have prebuilt graphs. So, you have to stick with them, unless you are going to use a third-party tool to create them, and then you are going to upload them to the BI tool. In Power BI, they started supporting this functionality and created a tool for that, but it isn't yet complete and mature. It is still exceeding the expectations and is better than most of the BI tools when it comes to creating custom graphs, but it needs more enhancement and simplification. It would be good to have a design tool provided by Power BI to design the graphs that we want and set the figures that we want on them."
"In Microsoft Excel, you are able to have tabs. However, in Microsoft BI you do not have this flexibility."
"We need more integration capabilities."
"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."
"I would want them to have more options as a user. It would be nice for them to create their own dashboards and add fields."
"This solution would be improved with the inclusion of a feature that would allow us to add a common library of (our) commands used in load scripts and expressions, so with a keyword, we would get a drop down to select the command we are looking for, as opposed to the generic help."
"Syntax editor needs some work, it's frustrating to have valid syntax being flagged as incorrect."
"There is no automation or drag and drop functionality."
"I really wish the application was easier to use in the development phase."
"Though the initial setup phase is simple, when it comes to the integration with the custom systems, the configuration and the compatibility sometimes take some more time."
"Scalability really depends on the size of your data and QlikView server architecture. For the biggest data sets, it could become an issue at some point."
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.