Forum Discussion
Dynamic row level security not working on service
Hi Yes, I have added the role in the service and tested as that role, when I test as role this is where the table headers appear but no data.
Hi, if you happen to still be working on this two years later, or for anyone else that gets this as the first result:
The Usernames might not be what you think it is. In a medium article I found this hint:
"
Identify user in hierarchy
User Principal Name function, USERPRINCIPALNAME(), is the main method for identification. Note that this function return different values in desktop and in online service. The online name is what matter during RLS execution."
I had the same problem, and I was using [email protected], but the actual IDS in Power BI were [email protected] . So if you test [email protected] in desktop it will work, but when you test the individual in live, it will use their ID email, and it won't work.
Hope this helps someone!