Yes, but it works out to be essentially the same method, just with some redundancy. For example, if you had sales reps that only get access to their divisions, you can set that up, but then you'd also list the CEO next to each division so they'd have access to everything. It ends up just being multiple rows that the CEO is listed, making sure every division is listed for that email. Let me know if that makes sense!
@@hristohristov319 Ah. The way it's structured, the RLS either fully applies or doesn't apply to the visuals, so I don't think there's a workaround option unfortunately.
Any email address works, but it has to be associated with a Google Account to effectively log in to Looker Studio. So Google domains are all easy, but Microsoft accounts (or other) just need a created affiliation to a Google Account
Thanks for the video! Is it possible to apply RLS to some of the users only while the rest have the full access?
Yes, but it works out to be essentially the same method, just with some redundancy.
For example, if you had sales reps that only get access to their divisions, you can set that up, but then you'd also list the CEO next to each division so they'd have access to everything.
It ends up just being multiple rows that the CEO is listed, making sure every division is listed for that email.
Let me know if that makes sense!
Thank you for the prompt reply!
This is the approach that I was going to use, but I was hoping for a smarter workaround :)
Cheers!
@@hristohristov319 Ah. The way it's structured, the RLS either fully applies or doesn't apply to the visuals, so I don't think there's a workaround option unfortunately.
Thats exactly what i wanted!
Glad we could help!
omg this helped alottt very under rateddd video
So glad to hear it!
email needs to be a gmail ?
Any email address works, but it has to be associated with a Google Account to effectively log in to Looker Studio. So Google domains are all easy, but Microsoft accounts (or other) just need a created affiliation to a Google Account
@@pineappleconsultingfirm thanks ill look into the affiliation characteristic you mention