I’m managing a 10-page dashboard split across 4 different divisions (e.g., Finance, Marketing, Operations, etc.). Each page is specific to one division, and I want to ensure that users can only view the dashboard pages relevant to their division. For example:
- Finance users (User A1, A2, A3) should only access Finance dashboard pages
- Marketing users (User B1, B2) should only access Marketing pages
- and so on…
I’ve tried implementing access control at the dataset level using BigQuery Authorized Views, essentially creating separate views per user. However, this approach is becoming hard to scale and manage, especially as the number of users and dashboards grow.
Unfortunately, I can’t find a built-in setting (in Looker Studio Pro) that allows me to restrict access at the dashboard page level based on user roles or groups. So my questions:
- Is there a way to dynamically control access to dashboard pages or components based on the user’s division?
- Are there scalable alternatives to dataset-level restrictions (like authorized views per user) in Looker Studio Pro?