Forum Discussion

Ossy81's avatar
Ossy81
Helper I
3 years ago
Solved

RLS in Sharepoint

Hi,   we want to publish a powerbi report in Sharepoint and apply RLS, but it doesn't work with the webpart. Do you really need to implement this with the "embedded" code with the service principal...
Need Help
  • Burningsuit's avatar
    Burningsuit
    3 years ago

    Hi Ossy81 

    RLS with Sharepoint webpart usually works.

    If you have RLS configured on a Dataset, then take a Report from that Dataset and put it on Sharepoint with the File/Embed Report/Sharepoint Online link. 

    Users will be able to see the Report in Sharepoint provided...

    1) They have a Power BI licence

    2) The Report has been shared with them or they have access to the Workspace.

    3) If the Report was shared they will be subject to RLS, if they have access to the Workspace only "Viewers" will get RLS all others will see all data.

    4) If they are subject to RLS they will need a Role in RLS.

    Hope this helps

    Stuart

Burningsuit's avatar
Burningsuit
Resident Rockstar
3 years ago

Hi Ossy81 

RLS with Sharepoint webpart usually works.

If you have RLS configured on a Dataset, then take a Report from that Dataset and put it on Sharepoint with the File/Embed Report/Sharepoint Online link. 

Users will be able to see the Report in Sharepoint provided...

1) They have a Power BI licence

2) The Report has been shared with them or they have access to the Workspace.

3) If the Report was shared they will be subject to RLS, if they have access to the Workspace only "Viewers" will get RLS all others will see all data.

4) If they are subject to RLS they will need a Role in RLS.

Hope this helps

Stuart

Ossy81's avatar
Ossy81
Helper I
3 years ago

Thanks 🙂 Just missed a step in the RLS setup 🙂

It's working now indeed.. Was afraid i had to set it up like you have to do when embedding it into a external app/site.

 

THanks for you help!