Forum Discussion
RLS not working after refresh ends
Hi, I have set a RLS on power bi desktop [my column = username()]. When i view as the user on power bi desktop it works fine, but when i publish it to the service it works fine only until the re...
1) Have all the users been added to the RLS role in the service?
2) This might be the issue from here .
"Within Power BI Desktop, username() will return a user in the format of DOMAIN\User and userprincipalname() will return a user in the format of [email protected].
Within the Power BI service, username() and userprincipalname() will both return the user's User Principal Name (UPN). This looks similar to an email address."
What format is in your column?
You can test by using it in a measure and dropping into a card visual to see what is being passed.