My company uses G Suite for Gmail and Google Drive. I would love to be able to point Power BI at the G Suite admin URL or some other Google URL to be able to:
- Display and aggregate mailbox users
- Display and aggregate drive usage by count and size
- by count
- by size
- by date created or date modified
Has anyone been able to do this yet? It looks like there are a couple of 3rd party tools to allow for this. From what I can tell the CData tool requires setting the connection up as an ODBC source. The TrayIO solution appears to require a datawarehouse to pull data into.
I have contemplated using Power Automate to get files but there is not a Get File (Properties Only) similar to the one for SharePoint that will pull in all items under a certain starting folder. Seing how this would traverse several terrabytes of info I don't think this would be the best approach.
Any other thoughts???