Forum Discussion
Row Level Security User names / criteria?
Hi Guys,
I have been looking at various videos, blogs, documentations were it uses a simple filter to implement Row Level Security where as I would like to use just the user names to filter out information for the matching client names. Attached is a sample information where it seems very simple but it just fails. I have even used the video tutorial shared by Paul Turley and it seems to working fine for him but I copied step by step and it just fails. Any help here would be of great help here.
Paul Turley video: https://www.youtube.com/watch?v=GpinnvFTdVU
sample file with data: https://1drv.ms/f/s!Aj7kf6Fnqc5SwmD-8Jv-HKxKd9N8
Kind regards,
A!
Anonymous here is simple change I made in your file to make it work, take a look. You can use "view as role" and test it.
5 Replies
Anonymous it is pretty straight forward to implement, when you said fail, are you getting an error or it is not working as expected?
Anonymous here is simple change I made in your file to make it work, take a look. You can use "view as role" and test it.
Thank you parry2k for the quick response and also to share the updated version of the .pbix file. Perhaps, I should have not focussed too much on the user principal function in the managerole filter option and should have used the simple logic.
Thank you for the file, it worked like a charm :)
Regards,
A!