Open Source Version Feature

FAQ
1

Hello,
i'm exploring Open Source Alternatives to Power BI. Metabase comes in almost all my searches. Before digging in the technical details of Metabase, I would appreciate if you could help me by answering the following questions:

1- the "developer" tool used to build reports and dashboards is it web-based or desktop based?
if it's webbased, could it be installed on Ubunto Servers?
if it's a desktop based, is it only for windows PCs?

2- Does it support Row level security? same report, different users, each one having access to certain data (by country, by brand, etc.)

3- Does it allow publishing and sharing? publish the report to a certain repository allowing other users to view them in a read only mode, without the possibility to download it nor to modify it.

4- Does it allow automatic scheduling? configuring the report to refresh at a certain frequency

5- Does it allow sending Alerts via emails? for example, when a certain KPI reaches a certain threshold, an email is broadcasted to a list of recipients.

6- Does it allow secure embedding in other web applications? a certain report is being displayed within other web applications.

7- Any other information you may provide would be extremely helpful.

Regards,
Sami

2

Hi @sassi

  1. Metabase is web-based application and can be installed on any computer that supports Java https://www.metabase.com/docs/latest/installation-and-operation/running-metabase-on-debian
  2. There's Sandboxing available in the Pro/Enterprise https://www.metabase.com/docs/latest/permissions/data-sandboxes
  3. Not sure if you are asking for public sharing https://www.metabase.com/docs/latest/embedding/introduction or just normal permissions https://www.metabase.com/docs/latest/permissions/collections
  4. All queries are directly to the database by default, so they are instant and up-to-date. There's https://www.metabase.com/docs/latest/configuring-metabase/caching and https://www.metabase.com/docs/latest/data-modeling/models#model-caching for various caching functionality.
  5. https://www.metabase.com/docs/latest/questions/sharing/alerts
  6. https://www.metabase.com/docs/latest/embedding/signed-embedding
  7. You can likely find the answers to all of your questions simply by looking in documentation https://www.metabase.com/docs/latest/ or learn articles https://www.metabase.com/learn/, or try searching this forum.
3

Thanks @flamber for your help. I'll certainly read the shared documentation.