Tutorial - Tenant-level usage metrics, site/subsite/list/library inventory with Power BI

Hi folks, sharing this here because I think it might be useful to fellow SharePoint admins. Long story short, there's lots of good data in the OData feeds in SharePoint, and you can access those with Power BI. The feeds are site-level, but using a function you can take your query and have it iterate over all of your SharePoint sites to create a tenant-level set of reports and schedule refresh on that in the Power BI service.

The sites query has a lot of the same data you'll find in the admin center, so all-time/recent views, last modified date, site template, etc. The value-add here is that Power BI can get the subsites, which you will not see in the admin center. Since we're phasing out subsites, it's useful to get an inventory to see what needs to be replaced/moved/archived. The lists query has item counts as well, which can be good for keeping an eye on things approaching the 5k list view threshold. 

I did a couple videos on how to get started with this technique here, planning on adding more as time goes by:

Get sites and subsites: https://youtu.be/qYhXdNDnyfI

Get lists and libraries: https://youtu.be/_MHRH3EbSuk

Credit to Jordan Murphy as well, who figured out how to do this and asked me to share the technique. 🙂