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."I would rate the stability a ten out of ten. I didn't face any issues with stability."
"We can centralize all our data models."
"The stability of Looker has been good since I have been using it. However, it depends on what components are being used."
"It is a pretty stable solution because it is a cloud-based product."
"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."
"With Looker, I have experienced benefits in terms of usability and shareability."
"From a developer's perspective, the way the functionality's being handled is great."
"The product is easy to use."
"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."
"The visuals are great and make everything look very professional. We can change the look and feel or manipulate the data according to our requirements. It's extremely flexible."
"The best feature of this solution is the way you can plan, communicate, and visualize all the knowledge you extract from the data for the customers. I like the way you can show or visualize the information a client needs to answer a business question."
"There was a lot of manual work involved with Excel, whereas once we moved on to Microsoft Power BI, it was a cleaner dashboard and it was faster too."
"The solution has a good toggling feature."
"Power BI allows you to create user defined charts which is really useful."
"It's the analytic engine in terms of the interface on the Power BI environment, as opposed to pivot tables, and it's a mobile solution."
"The visualization part and its inclusion in a cloud-based application are valuable features."
"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."
"It needs to be more user-friendly."
"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."
"Integrations with other BI tools could be better."
"Stability needs improvement."
"The product does not have documented material."
"The integration with different databases must be improved."
"Power BI could be improved by implementing more options for data integration. Nowadays, the cloud takes care of scalability and security. As we all know, data sources are increasing, so we get data from a variety of streams. But if we could get the downstream data into the database and update the reports more easily, Power BI would be better."
"Most clients have MacBooks. Therefore, they use Tableau as Power BI Desktop is not available for the MacBook right now."
"Microsoft BI has its own challenges in terms of user interface and how quickly somebody can learn how to use it."
"There is no column-level security in Microsoft BI, and this is a feature that most of our customers are looking for. That is something that should be implemented."
"The integration with third-party products could be more stable."
"I have to write scripts to query data for analyzing performance."
"Microsoft Power BI can be confusing, because it has two languages that you need to learn if you want to use it, and this makes it more difficult for nontechnical users."
"The handling of the workspaces can be made more granular for user access rights. It can be managed a little bit better in terms of the connection to Active Directory so that we have more granular access rights. I am not sure if this is really possible or if we can solve it differently, but we need a lot of workspaces, and we are not sure how we can deal with it from the access rights perspective."
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.
