Possible to scan Sharepoint groups to get a list of members?

[OneWithQuestion]

Is there a way with Power BI to read the list of members inside specific Sharepoint groups?

[JamieHankins]

User Information List gives me a long list of everyone that has access to a group, but includes visitors and not just members/admin. No obvious way to filter it down either. 

[jbwtp]

Hi @OneWithQuestion,

I think there is no simple way to read a list of O365 (which is what actually the Sharegroup is) members in Power BI from what I know. There is a User Info List in the Sharepoint Lists connector, but it does not bring anything valuable for me:

The workaround could be using Power Automate to generate HTTP request/response (from memory it can read user details in O365 groups) and use it as a source for Power Query via Web connector.

Cheers,

John