Forum Discussion
Row Level Security - Filtering Issue On Publish
Hi Davidian
I have not experienced the same issues that you have experienced with regards to re-level security What I would recommend doing is making sure that you have followed the row level security best practice. In doing so in doing so that should work as expected, especially when using the drop downs and slices.
I would recommend following this blog post from Kasper which you can test to see if it works as expected: Power BI Desktop Dynamic security cheat sheet - Kasper On BI
Forgot to say - thanks for what you have supplied - I have been playing and it allowed me to notice something else that I didn't realise about power bi and our internal system.
The perms DB as EMAIL and doesn't have UPN but UPN is the same as EMAIL for MOST people but as a fallback I also had UN in there which is in the perms DB - but once you publish to webservice it doesnt use the local UN it basically becomes the UPN lol
So, I am getting the UPN loaded in to the DB and then will update the tables etc and see if that fixes the RLS issue with the drop down still needing a filter on it once published to web and come back to you.
Cheers!