Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

Query SPO users and permissions?

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...

Community Support
Community Support

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




Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors