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 ...