Forum Discussion
Helper IRLS 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 setting etc? This is only used internally and was hoping that it would be easier in Sharepoint to publish with RLS.
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
2 Replies
- Burningsuit
Resident Rockstar
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
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!
