Query G Suite data from Power BI

[jschaefer]

Hello,

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:

1.  Display and aggregate mailbox users
2. Display and aggregate drive usage by count and size
   1. by count
   2. by size
   3. 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???

Thank you!!!!