Forum Discussion
Sharepoint - Access rights
Hello everybody,
I am connecting Power BI to Sharepoint to visualize some data (see screenshot below). Afterwards I want to share the report to my colleagues. I have view rights for all elements of the Sharepoint, most of the other users (~200) have dedicated access for the entries (granted individually ad via groups). However, when I share the Power BI report, the users can see all entries. My question is whether it is possible to create the Power BI report in such a way that everybody can only see the same data/entries as in SharePoint. The semantic model is actually connected to SharePoint via OAuth2 with the privacy level "private".
My first idea was to use roles / row-level-security but this would mean a lot of work because there are thousands of entries in SharePoint and the access rights are given individually for all of these entries.
It would be great if someone could give me some advice. Thank you
You would need to set up row-level security in Power BI for this. You can use the same rules, USERPRINCIPALNAME() on the created-by email address to filter. There's not a native integration for it to "use the source permissions" on the data model for SharePoint (there is for Dataverse, though).
1 Reply
- christinepayton
Most Valuable Professional
You would need to set up row-level security in Power BI for this. You can use the same rules, USERPRINCIPALNAME() on the created-by email address to filter. There's not a native integration for it to "use the source permissions" on the data model for SharePoint (there is for Dataverse, though).