Forum Discussion

Rayzo92's avatar
Rayzo92
Helper I
3 years ago
Solved

How to implement RLS even while working with the dataset/datasource

Greeting dear members ,    I have a problem in one of my project and hope you guys can help me with a trick i dont know (in my company we do have premium license for information ) :    I have pro...
Show and Tell
  • Burningsuit's avatar
    Burningsuit
    3 years ago

    Hi Rayzo92 

    How are the users accessing the Dataset ?

    Generally, if you have implemented RLS on a Dataset, if you share a Report from that Dataset with a user (or the user is a "viewer" in the Workspace), that user is subject to RLS in the Report AND the underlying Dataset. They can access the Dataset via the "Data Hub", or connected to it via Power BI Desktop and build new Reports based on the Dataset but are subject to RLS on that Dataset.

    All you need is to ensure is they have "Build" rights on the Dataset, and even though they are subject to RLS they will be able to build Reports with the data they are allowed to access. Conversely, if you revoke "Build" rights on the Dataset the users will not be able to build Reports on that Dataset.

    Of course if you make the User anything other than a "Viewer" in the Workspace, or give them "Write" permissions on the Dataset they will not be subject to RLS and will see all data.

    Hope this helps

    Stuart

     

Burningsuit's avatar
Burningsuit
Resident Rockstar
3 years ago

Hi Rayzo92 

How are the users accessing the Dataset ?

Generally, if you have implemented RLS on a Dataset, if you share a Report from that Dataset with a user (or the user is a "viewer" in the Workspace), that user is subject to RLS in the Report AND the underlying Dataset. They can access the Dataset via the "Data Hub", or connected to it via Power BI Desktop and build new Reports based on the Dataset but are subject to RLS on that Dataset.

All you need is to ensure is they have "Build" rights on the Dataset, and even though they are subject to RLS they will be able to build Reports with the data they are allowed to access. Conversely, if you revoke "Build" rights on the Dataset the users will not be able to build Reports on that Dataset.

Of course if you make the User anything other than a "Viewer" in the Workspace, or give them "Write" permissions on the Dataset they will not be subject to RLS and will see all data.

Hope this helps

Stuart

 

Rayzo92's avatar
Rayzo92
Helper I
3 years ago

Thanks for you reply , 

 

pretty much this is what i have done ! i shared the dataset with the viewers and i added the build mode aswell ! and the RLS was applied to the dataset