Get the size of all Azure SQL Databases

I need to produce a report showing all our Azure SQL Databases with their size. The databases are split among many resource groups in several subscriptions. I can get the information for a single instance, or even for all DBs in a resource group, but I have too many RGs to make that a workable solution, and I cannot find a way of getting the information for a whole subscription, or whole tenancy.