Forum Discussion
Dynamic row Level Security not working
- 6 years ago
Yes I did.
Ive tried this again on a brand new very basic report in a new App workspace and it worked.
I have done exactly the same process.
Thats absolutely the one I have used. I have read it so many times and mine still doesnt work
I think this is the thirs time I have attempted to do it from scratch using this blog. Are there any other blogs that I can follow for the same logic.
Basically the users who should only see their own information see all the info
And the user who should see everything sees nothing with this logic
HI DebbieE,
In fact, all records displayed not means your RLS works, it also appeared if users have edit permissions of your report.
Please double-check these user permission to confirm they only have read permission or RLS filter effect it works on these users.
Row-level security (RLS) with Power BI#using-rls-with-workspaces-in-power-bi
Regards,
Xiaoxin Sheng
- DebbieE6 years agoCommunity Champion
User 1 is Admin so seeing all records is OK
User 2 and User 3 havent been added to the app workspace. they have been added to the app
And with this logic the issue still stands.
User 2 sees all rows. User 3 sees nothing.
I just cannot get dynamic security working.
Instead of testing in Security (test as role) I got user 2 to go into the App and they cant see anything even though they should be able to see their information
I really dont know how to move forward with this one?