Hello everyone,
Data Description: I have a Looker Studio report with multiple dashboards, all connected to BigQuery for underlying data. Some tables in BigQuery are base tables, while others are external. Many data sources are created as views.
The Task: I need to create a filter that ensures certain people accessing the dashboard can only see their data tied to their email.
Tried Solutions:
I tried creating a filter on each dashboard within Looker Studio using LOWER(SESSION_USER()) AS viewer_email, and then creating a calculated field with a case clause:
IF person.email = viewer_email THEN TRUE. This approach didn’t work.
I tried giving BigQuery view access to specific users, but this didn’t help either.
I attempted to filter by email in the data source Edit section, but it filters the data so that I can’t see it, and users are shown a message saying, “You don't have access to the underlying data.”
I wanted to create a RAP (Row Access Policies), but since some of the dashboards are views or external tables, RAP cannot be created on them in BigQuery.
Summary: The task is a bit tricky, so I’m reaching out for help in finding a solution. Any suggestions or guidance would be greatly appreciated!
LinkedIn
Twitter
