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."
"We can centralize all our data models."
"The product is easy to use."
"It's quite effortless to navigate through various applications and review their updated data in real-time."
"I would rate the stability a ten out of ten. I didn't face any issues with stability."
"The stability of Looker has been good since I have been using it. However, it depends on what components are being used."
"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."
"It is a pretty stable solution because it is a cloud-based product."
"The way data is presented is very valuable. The amount of information that we can get at a glance is also valuable. You can then drill-down and see data from many different angles in the same chart by selecting certain things. Based on the selection, everything changes automatically. If we have four parameters in a particular item, when you select a parameter, the remaining charts on that page automatically change for that particular parameter."
"The solution is stable."
"We have found the solution to be stable."
"It's similar to Excel, but it's much more powerful than Excel."
"I like how the Query Editor lets me manipulate the data, and the available visuals are good. You can do everything using the UI."
"You don't need much support with Microsoft Power BI because it has such a large base of users who can answer your questions on their forums. There are also many video tutorials and webinars available online that offer solutions to whatever problems you may have."
"There is a feature in Microsoft BI that allows JSON data to SQL on the dashboards effectively and quickly."
"I like data modeling. You can connect with your database, which is quite useful for me. It is a good tool if you have a large amount of data and you want to gather different data and interconnect it. The Power Query functionality is quite an interesting feature. If you have a query in Excel, you can also copy your query and run it in Power BI. Its dashboard is also very nice and not complicated. You don't need to be a developer to be able to use it. I am not an IT guy, and it is quite easy to use for somebody who is not an IT person."
"It needs to be more user-friendly."
"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."
"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 integration with different databases must be improved."
"Stability needs improvement."
"The product does not have documented material."
"I would like to see better, undisturbed stability without any interruptions."
"It seems that the solution could use more analytics to help users draw more contextual business insights. Right now, you need other solutions for that."
"Its setup and support should be improved. We would like to see more material for developers that provides clear explanations about how we can do data mining by using Microsoft BI. It would also be good if we can connect a feature to other customized machine learning solutions."
"The data source definition is all over the place."
"I would like Microsoft to include some inbuilt machine learning so that it becomes point-and-click, rather than us developing models out of API and BI connecting to that and getting the results. That process gets in the way of continuity."
"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."
"Microsoft BI lacks integration capabilities, so it needs to consider increasing its integration capabilities."
"Its price could be better. Its licensing cost is very high."
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 IBM Cognos, 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.