Row Level Security User names / criteria?

[Anonymous]

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!

[parry2k]

@Anonymous it is pretty straight forward to implement, when you said fail, are you getting an error or it is not working as expected?

[parry2k · Accepted solution]

@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.

[Anonymous]

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!

[Anonymous]

Hi @parry2k,

I was able to succesfully test the content but this does not seem to be working for visuals which has been created already in my report. should I have to reference a binding factor in all the visuals to be able to use the RLS feature? as this does not seem to be working for slicers too 😞

Thanks in advance. 

Kind regards,

A!

[parry2k]

@Anonymous not sure why it wouldn't work until I'm not seeing the full picture. Can you share how your data model looks like? Whch visuals are not getting filter?