Try our new research platform with insights from 80,000+ expert users

Knowage vs Microsoft Power BI comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 1, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Knowage
Ranking in BI (Business Intelligence) Tools
33rd
Ranking in Reporting
25th
Average Rating
7.6
Reviews Sentiment
6.7
Number of Reviews
18
Ranking in other categories
No ranking in other categories
Microsoft Power BI
Ranking in BI (Business Intelligence) Tools
1st
Ranking in Reporting
1st
Average Rating
8.0
Reviews Sentiment
7.2
Number of Reviews
326
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of October 2025, in the BI (Business Intelligence) Tools category, the mindshare of Knowage is 0.7%, up from 0.5% compared to the previous year. The mindshare of Microsoft Power BI is 14.1%, down from 21.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
BI (Business Intelligence) Tools Market Share Distribution
ProductMarket Share (%)
Microsoft Power BI14.1%
Knowage0.7%
Other85.2%
BI (Business Intelligence) Tools
 

Featured Reviews

BS
Open-source with great embedding capabilities but the dashboards could be better
I know the initial setup is pretty straightforward. It doesn't take a long time to deploy. Even on your own personal computer, when you want to try it out, it doesn't take too long to get it running. For the initial setup, I'd say it's maybe a four out of five in terms of how easy it is. You need to add these Java dependencies and so forth, which can be a bit boring, however, it's almost perfect. To deploy Knowage usually takes about a day. In terms of the implementation strategy, it's just following the instructions that they give us on the installation and then just knowing how to handle the process. Usually, there is a group of engineers who do that for us and manage the server itself. If a team is knowledgeable, then it doesn't take a long time. When you need a new instance, it's very quick. The implementation strategy is based on just following instructions on the installation process from Knowage. For deployment and maintenance, we need just maybe two people simply to monitor the traffic coming in. However, it's maintained by people who were doing other jobs like maintaining our other server. They just monitor the Knowage server and make sure that it's up and running and that there are no bugs. There are not too many bugs coming out from the debugger.
Shoury Priyanshu - PeerSpot reviewer
Facilitates seamless data aggregation with some outdated visual elements hindering user appeal
Real-time data integration is an area for improvement. Although I've worked on several solutions involving real-time integration, it's not very user-friendly and often lags, especially with over a million data rows. This makes Power BI difficult to manage as loading times can reach one or two minutes, which is problematic today. There are challenges with scalability, requiring multiple pages in dashboards to manage these issues. Visualization could be improved as it appears outdated. Users, especially newcomers, find it unappealing and not user-friendly.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"We can easily do our own customizations."
"I can't name the features the way the Knowage community calls them because I still don't know the lingo. However, I can describe them. I like the ability to join more than one report, set all fields on one end, and replicate that on the other reports. I like that a lot. I think it's one of the features that got me using Knowage. They have tables, and I like that too. They took SQL scripts and many other scripts and enabled them to even correlate with Python. That's also one of the best things about Knowage. You could also decide to get information per user role, and this is also a feature that I like in Knowage."
"The concept of engines is quite powerful allowing the user to work with report authoring/provisioning tools of their choice."
"The embedding feature is great."
"The most valuable feature is integration with Python."
"The data manipulation and data cleaning tasks are handled in the backend by Power Query in Microsoft Power BI."
"The initial setup is straightforward."
"Two valuable most features are the ability to create columns and create measures."
"The most valuable features are the flexibility, how many ways you can interrogate the data, and the the graphical visualization."
"What I liked most about the tool is that we can use text queries to create projects and modify columns according to our needs. There are hundreds of YouTube courses on how to use it."
"The initial setup is simple to do."
"The most valuable feature of Microsoft Power BI is the drill-through feature that takes you to a details page the users want to see."
 

Cons

"Development of SpagoBI has now been moved to Knowage. Users interested in further developments of the platform will have to look there."
"The dashboard components could be better."
"It would be better if more resources were available to help us learn how to use it. I wanted to use Knowage for a more extended period, but learning materials around the product were not really available and were not really straightforward. I've also seen inconsistencies between versions. For example, under the tools, especially in the cockpit, the way you create reports is now different. You will also find some configurations within a particular state, like a line chart, which differs from version to version. I think consistency is an essential feature in a product, especially for business intelligence products."
"The only challenge here is that it's a Java-based platform. It requires very high technical skills."
"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."
"It was easy to implement Microsoft Power BI into our existing infrastructure, but integrating it with Oracle Cloud was very difficult. The integration with Oracle Cloud required us to build a sophisticated database replication process because the APIs for Oracle Cloud are very restricted in terms of volume, depth, and complexity of queries. However, the part of implementing Power BI into our infrastructure was very easy. It required almost no tech input because it was all part of Office 365. To overcome the integration issues, we developed an extract and update process, although it was quite complicated and involved a lot of IP. Power BI excels in integrations and its ability to handle various data sources. It would be beneficial if it could integrate more seamlessly with cloud interfaces like Oracle Cloud, although I understand the challenges with Oracle's policies on database access. Another area for improvement would be enhancing error messaging, especially when working with Dataverse and M Code for automation."
"Areas for improvement would be the construction of reports and the dashboard budget."
"Microsoft BI has its own challenges in terms of user interface and how quickly somebody can learn how to use it."
"The solution could benefit by allowing deeper data analytics."
"I am taking a course to be able to use the solution better. Some aspects of the solution are not straightforward."
"I think that there should be visuals for financial reporting videos. It should just be a plug and play because there is a lot of coding that goes into it with different clients."
"It is kept very current, and there is an update literally every month. However, the interface changes quite randomly with no documentation, which is difficult at the domain and architectural level where you're planning things and engaging the business. Things change frequently, and you wonder where has the button for the new report gone. They should provide better documentation on interface changes. It should be better optimized. It is supposed to be a data integration tool, but it is doing relatively simple queries. It has its limitations. For example, you can only pull a number of columns. So, there is room for optimization on its ability to integrate multiple data sources. The desktop tool is very memory-intensive, and again, this is not documented clearly. It requires a heavy CPU and memory use, and it causes your operating systems to become unstable. I would like to see the ability to create datasets within Power BI. Microsoft is promoting Azure as a cloud solution, but it is dependent upon a desktop component, which seems a little bit deceptive. Data set is the basic element that you report from, but it has to be created on the desktop and then published to the cloud. So, you're in the cloud, and you create a data structure or the data flow, but you can't report from that. You have to leave the cloud, go to your desktop, create the data set on your desktop, and publish it to the cloud. You go back to the cloud and create your report by using that published data set, which is very non-intuitive. If you go to the Microsoft Power BI community, this is a common complaint across the entire community."
 

Pricing and Cost Advice

"Knowage is open-source, and an enterprise edition is also available."
"It allows the implementation of an effective reporting system using internal skills at a limited upfront cost."
"The solution is affordable."
"Microsoft BI is not expensive."
"Its pricing is reasonable for the desktop stuff, but for enterprise-level, it is a little expensive."
"Downloading Power BI Desktop is free."
"Microsoft BI for desktop is free to use, and you can download and use it."
"Power BI comes with enterprise Microsoft licensing. So for the user, you don't have to pay, but you do have to pay a one-time cost."
"We have a professional license for Microsoft BI and the price is fair."
"This solution came free, it was offered by Microsoft with our E3 license."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
869,785 professionals have used our research since 2012.
 

Comparison Review

it_user79932 - PeerSpot reviewer
Feb 4, 2015
Comparison of SAP BO, Tableau, QlikView, Cognos, Microsoft, OBIEE and Pentaho
1. SAP BO/BI Enterprise scalability Security Ease of use Semantic layer 2. Tableau Visualization Data discovery Turnaround time 3. IBM Cognos Enterprise scalability Security In-memory feature 4. MS BI - Flexibility 5. Pentaho - Open source but still enterprise grade 6. QlikView Data…
 

Top Industries

By visitors reading reviews
Hospitality Company
13%
Government
11%
Insurance Company
9%
Retailer
7%
Financial Services Firm
12%
Government
9%
Computer Software Company
9%
Manufacturing Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business7
Midsize Enterprise6
Large Enterprise6
By reviewers
Company SizeCount
Small Business134
Midsize Enterprise57
Large Enterprise165
 

Questions from the Community

Ask a question
Earn 20 points
Seeking lightweight open source BI software
There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would recommend as follows: 1) If you have legacies of SAP, Oracle - look for SAP...
Is Power BI a complete platform or only a visualization tool?
Power BI is an advanced visualization tool oriented to big data with a very complete set of widgets to visualize information, control users accessing information, the configuration of governance po...
How does Oracle OBIEE compare with Microsoft BI?
Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are fully customizable and very user-friendly. This solution is very stable. Oracle ...
 

Also Known As

SpagoBI
SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
 

Overview

 

Sample Customers

FIAT Group, Italian air navigation service provider, Ministry of Education and Science of the Russian Federation, Telecom Italia, ASL Genovese, San Giovanni Battista University Hospital
Accenture Adidas Aetna AIG Airbus Alibaba Allstate Amazon American Express Aon AT&T Audi Bank of America BASF Bayer Berkshire Hathaway Boeing Coca-Cola Comcast Cisco Coca-Cola Dell Disney Emirates Equinix FedEx Ford GE Google H&M Home Depot Honda IBM Intel JPMorgan Chase Kellogg's Kroger L'Oréal McDonald's Merck MetLife Microsoft Nike Oracle P&G PepsiCo Procter & Gamble Prudential Financial SAP Siemens Snapchat Spotify Starbucks Target Toyota T-Mobile Unilever Visa Walmart WeWork World Bank Xerox
Find out what your peers are saying about Knowage vs. Microsoft Power BI and other solutions. Updated: September 2025.
869,785 professionals have used our research since 2012.