How to view Sharepoint list item "Shared with" values on Power BI?

[Anonymous]

I have a sharepoint list, it contains all the reports used by our organization. Each of this report is a sharepoint list item and is shared with multiple users.

I want to see all the users with whom each report is shared with.

How do I extract all the users for each list item on Power BI?

[Anonymous]

Hi @Anonymous ,

In my opinion, you can consider to admin account to connect sharepoint api to get detail sharing information from related table.

List and library column types and options

Regards,

Xiaoxin Sheng