Sharepoint files and folders permission dataset

[Anonymous]

Hi 

Is there are a way we can extract data of who got access to which folder and files in Sharepoint Online as Power BI dataset. 

In SPO add and remove users to folders and files and want to get a visiblity of who has access to what and report on Power BI. 

thanks 

[v-zhenbw-msft · Accepted solution]

Hi @Anonymous ,

Please refer to the following two posts.

https://community.powerbi.com/t5/Desktop/How-to-display-an-assigned-user-in-a-sharepoint-list-in-Power-BI/td-p/32146

https://sharepoint.stackexchange.com/questions/234755/how-to-get-a-list-of-site-subsite-users-with-permissions

If you have any questions, please kindly ask here and we will try to resolve it.        

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.