Any side by side comparison of Power BI vs. Apache Superset

[simonsun]

Is there a side by side comparsion between Power BI and Apache Superset?

Data source in this case is in ClickHouse, and with high volume.

Seems both scalable, and able to integrate with ClickHouse (e.g. PowerBI via ODBC driver?), and able to support customized query, etc.

Any pros and cons comparision? 

[v-henryk-mstf · Accepted solution]

Hi @simonsun ,

For Power BI and Superset, the following are their main differences:

For both BI products, they both have advantages in custom queries. But for Apache Superset, its characteristic is that it has SQL/IDE editor with interactive querying. The query of powerbi is to operate on the imported table. There is no Apache Superset convenient for interactive query.

Here is reference link.

Power BI vs Superset | What are the differences? (stackshare.io)

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[simonsun]

thanks, this is useful.

I still need a detailed comparison, especially on customized query.

[AlexisOlson]

This is the best I can find but it's compared to Tableau:
https://www.xpand-it.com/blog/apache-superset-open-source-bi/

It looks to me like Apache Superset only has a very thin semantic layer and isn't suitable for creating dimensional data models.