Forum Discussion
PowerBI Integration with multiple sharepoint
Hi sclement ,
Have you managed security on your data model in Power BI Service like below?
Reference: Row-level security (RLS) with Power BI - Power BI | Microsoft Docs
I tried this. Eventhough when I filtered the data for a certain department usiand given the premission to view the department data view to my manager, but he was able to see the all data without filtering. Was it because he is the owner of sharepoint?
No, it doesn't matter if it is the owner of SharePoint or not, it has to do with the role in the Workspace.
What's your manager's role in the corresponding workspace? He/She can only be a "Viewer", or none role of the workspace. RLS doesn't work for Admin, Member, and Contributor in workspace.
If you publish your Power BI Desktop report to a new workspace experience in the Power BI service, the RLS roles are applied to members who are assigned to the Viewer role in the workspace. Even if Viewers are given Build permissions to the dataset, RLS still applies.
Reference: Using RLS with workspaces in Power BI
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi sclement ,
Have you tried to use Row-level security (RLS)?
When using the Embed in SharePoint Online option, the embedded reports respect all item permissions and data security through row-level security (RLS), so you can easily create secure internal portals. For detailed steps, please check:
Embed a report web part in SharePoint Online - Power BI | Microsoft Docs.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.