Is Role-Level Security (RLS) Case Sensitive for Email Addresses?

[Nikkitea]

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. 

[drumroll]

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?

[ibarrau · Accepted solution]

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,

[Nikkitea]

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.