Hello!
We had an issue where the “Consent Required” dialog does not work when adding viewer email data filtering to a Looker Studio report.
We have a report in Looker Studio, where the primary data sources come from BigQuery. We need to restrict data access at the row level for users. To achieve this, we created a table with a list of allowed data by email and are using the “Filter by viewer’s email address” feature. The table was created in BigQuery and then transferred to Google Sheets, which is connected to Looker Studio as a data source.
The problem is that for users with Viewer access, the permission to view their the email address does not work. When they click “Allow” in the consent dialog, the permission is not applied. The user does not see any data, and the dialog keeps reappearing.
For users with Editor access, the permission is applied, but only after reconnecting the data source with the access control list (via Manage Added Data Sources → Edit Connection → Reconnect).
What needs to be done to make email-based data access work for Viewer users?