Forum Discussion

prajaktakeni11's avatar
prajaktakeni11
Helper I
2 years ago

RLS on Power BI Server

Hi, I'm new to RLS. To start, I believe RLS is used to restrict data view.
Second, I'd like to know if I can type my employee ID and have the data displayed, including my EMP ID.

 

Can I use RLS to fetch data from the backend because my datasets are vast in size? I want to load only the data that is connected to my entred EMP ID. Is this possible?

Please assist I'm grateful in advance.

 

Report server RLS row level security

1 Reply

  • josef78's avatar
    josef78
    Memorable Member
    2 years ago

    Yes, you can (row level) restrict data for current user, based on USERPRINCIPALNAME() with simple or comlex rules. Probably you will need some additional data structure/map, because PBI do not know nothing about your "employee ID". PBI know you login name or user principal name.

     

    RLS is supported for all three modes (Import, Direct query and Live connected), but Direct Query (if you want fetch only filtered data) generally has some limitations.