Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello everybody,
I want to build a SharePoint Based Dashboard to get following information:
The only way I know is to extract data from a SharePoint Hub an its connected collections is with a PowerShell script and import the created csv file to PowerBI.
Is there an other way to driectly connect to the sharePoint Admin Center e.g. ?
Thank you in advance!
Would you be up for sharing your powershell code? And did you ever find a solution? Thanks
Hi @v-jingzhang Thank you for your suggestion. I'll try to get any data from the Usage Report and import it to Power BI. I'll update here as soon as I tried the solution.
Best Regards
Hi @itriada365
I don't find ways of connecting to SharePoint Admin Center directly from Power BI. There is no such connector currently.
If you want to see overall usage data of SharePoint service, you could try a template App Microsoft 365 Usage Analytics in Power BI Service. Or you can view SharePoint Site Usage report in Microsoft 365 Admin Center.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 30 | |
| 28 |
| User | Count |
|---|---|
| 128 | |
| 88 | |
| 79 | |
| 67 | |
| 62 |