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 Icey,
Thank you for your suggestion.
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?
Sorry, as I am just beginer and so I am not familar with all these. Can you help me sort this out?
Thank you very much!
Regards,
Sachin
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.