Hi everyone… I wanted to know if in Metabase it’s possible to grant access using filters. For example, in Power BI, when you created a dashboard and added a filter by company, you could then give access to users from each company so they would only see information for their own company and not others.
Is this possible in Metabase? If the answer is “yes,” when using embedded mode to include the dashboard in another platform, can this type of more granular filtering also be applied?
It is, and how you do it depends on how users are interacting with Metabase.
For embedded/static dashboards, use a locked parameter through the JWT to set the company ID.
For interactive embedding or Metabase app access (where the user has a Metabase account), roll out row level security and set an attribute in the user record to lock them to a company ID.
hi @dwhitemv … Could I manage my own dashboard platform, embed Metabase dashboards there, and—by using the “PRO” plan—leverage the “row-level security” and “SSO with Azure AD” features? With this approach, I would create users in my Azure AD so they can sign in to my portal, and based on the authenticated user, they would only be able to see the dashboards that correspond to them (and not others), while also enforcing granular access control at the dashboard level through user-based filters.