Count documents and size in SharePoint libraries using Power BI

Very common scenario requested is to show how many documents are there across document libraries in a SharePoint site and the file sizes. Unfortunately, SharePoint does not offer this out-of-the-box even for a single document library. Luckily, the new Power BI does offer this capability, albeit not well known. I literally stumbled upon this. Here