Forum Discussion
Is Role-Level Security (RLS) Case Sensitive for Email Addresses?
Hi there,
I added 9 users to the dataset security settings for a pilot dashboard I'm working on and during RLS testing 7 out of the 9 users had data displayed on the report. 2 others users are not displaying any data despite being configured the same way by email address: [Email] = Username(). The only noticeable differential I found was the email addresses containing an uppercase letter in the first name and last name (e.g. [email protected] at Microsoft Power BI service vs. [email protected] at data source). Is RLS case sensitive when it comes to email addresses? If not, what other cause could there be for this discrepancy in system behaviour?
I'll also add that I can see their data when I filter by name, so the data is definitely present.
Hi! I can't find an exact definition at microsoft doc but I assume it should be case sensitive. You can try adding LOWER () to the conditions to convert them to lowercase when comparing.
I hope that helps,
3 Replies
Hi! I can't find an exact definition at microsoft doc but I assume it should be case sensitive. You can try adding LOWER () to the conditions to convert them to lowercase when comparing.
I hope that helps,
Thank you! The suggestion surprisingly worked by turning the email username lowercase and I can see the data for the two impacted users now. This confirms there is case sensitivity to the email address in Power BI service.
Hi there, am having same problem, tried using LOWER([User]) = LOWER(USERNAME()) in manage roles on PBI desktop and published to service. I tried using the test role with the lowercase username and it doesn't work. How did you do make it work?
