We performed a comparison between Looker and Microsoft Power BI based on real PeerSpot user reviews.
Find out what your peers are saying about Tableau, Qlik, MicroStrategy and others in Embedded BI."From a developer's perspective, the way the functionality's being handled is great."
"Looker allows you to generate the most optimal SQL queries in a DC through UI actions. We had signed a contract with Google Cloud to use BigQuery. That was the primary reason we adopted Looker. It works better with BigQuery than any other BI platform. We also like how this tool was developed. It was designed with an eye toward microservices architecture."
"The stability of Looker has been good since I have been using it. However, it depends on what components are being used."
"It's quite effortless to navigate through various applications and review their updated data in real-time."
"It is a pretty stable solution because it is a cloud-based product."
"The product is easy to use."
"We can centralize all our data models."
"With Looker, I have experienced benefits in terms of usability and shareability."
"Very intuitive and easy to use."
"The amount of customization that you can do is good, and it's relatively straightforward to do."
"The solution has a good toggling feature."
"There is a feature in Microsoft BI that allows JSON data to SQL on the dashboards effectively and quickly."
"The most valuable features of Microsoft BI are the variety of possibilities to connect to various data sources. The visualizations are easily done, have useful rollover functions, and there are continuous updates being made to the system. You can benefit from the various improvements."
"There is continual improvement year-over-year."
"Easy to use. End-users can make changes to the graphics."
"This solution has improved our ability in making decisions and explaining data."
"The integration with different databases must be improved."
"The product does not have documented material."
"Integrations with other BI tools could be better."
"The main area of concern in Looker is probably related to blending the data from the different sources, including the data present internally in the company and on the cloud."
"Stability needs improvement."
"It needs to be more user-friendly."
"Looker doesn't connect to Excel, which is a huge disappointment because a lot of data is presented in Excel. Also, it can't consume data directly from REST APIs, which is necessary. Looker needs to expand its horizons when it comes to data sources. The inability to connect to different data sources is hampering our use cases. Currently, it only has an ODBC connection that connects to a database. It needs to connect to other data sources, such as Excel, APIs, and different platforms."
"The visualization capability of the product is limited."
"The UI is the main improvement that could be made. Specifically, there is something called DAX, in Power BI, which is complicated compared to calculated fields used in Tableau."
"Microsoft BI could improve by having better collaboration between developers working on the same dashboard. The developer platform is all done on a single laptop and it's difficult to have the same project files work. Two developers have to go back and forth. You have to have the project file on one developer's laptop making it difficult to co-develop."
"Microsoft BI lacks integration capabilities, so it needs to consider increasing its integration capabilities."
"It should be easier to use when there are multiple system sources."
"When it comes to improvement, I would say there could be more tutorials for students in universities who are just learning it. And it wouldn't have to be just for students in universities. It might also be for the people who use it in the real world."
"Microsoft BI typically connects to a database, often SQL Server, but it's also capable of connecting to multiple databases, pulling data from them, and allowing for data consolidation. You can then aggregate and generate dashboards and reports from this combined data. Personally, I wouldn't claim to have the expertise to suggest significant changes or additional features, as it functions quite well as is."
"I am taking a course to be able to use the solution better. Some aspects of the solution are not straightforward."
"The only concern I have faced with Microsoft BI is the time it takes to find out an issue and rectify it."
Looker is ranked 5th in Embedded BI with 19 reviews while Microsoft Power BI is ranked 1st in BI (Business Intelligence) Tools with 297 reviews. Looker is rated 8.0, while Microsoft Power BI is rated 8.0. The top reviewer of Looker writes "The APIs are exposed at every level, so it's highly modular". On the other hand, 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)". Looker is most compared with Amazon QuickSight, Tableau, Google Data Studio, Databricks and Domo, whereas Microsoft Power BI is most compared with Tableau, Amazon QuickSight, KNIME, Domo and Oracle OBIEE.
We monitor all Embedded BI 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.