I am struggling with an issue that we have with some of our scheduled reports.
Some background info:
In our portal we allow users to associate their email with more than one account.
We embed our looker dashboards in our portal and use the API to schedule the reports (using our own scheduler UI).
What is happening is that we see the dashboards with the correct information in our portal but when we receive a scheduled email of the report it has a different accounts information. It is information from an account with the same email address though. After looking into it, it looks like the data for the first account created in Looker with that email address is always being returned for the schedule reports.
Can we schedule reports using the user’s user_ID instead of their email address or does looker require all email addresses associated with an account to be unique? Is there a way to work around this?