Query SPO users and permissions?

[OneWithQuestion]

Is there anyway to query the users of an SPO site or site collection and all their permissions?

We want to look at doing some security auditing but would really want a way to be able to do this in a PBI dashboard so we can filter and drill, etc...

[v-juanli-msft]

Hi @OneWithQuestion

As far as i known, it is impossible to achieve this in Power BI.

After researching, you could use PowerShell script to get the list of all the SharePoint site collection administrators in the te....

Best Regards

Maggie