Extract metadata from Power BI

Hi everyone,

I've been given an assignment to extract the metadata from Power BI files into an excel file. Now the thing is they want it to be an automatic process. I have found a way to extract metadata from word documents into excel by using VBA. Here is a link to the excel file: https://exceleratorbi.com.au/extract-word-metadata-with-excel-vba/
The way you extract the metadata from word in the excel file is exactly the way I need it, but for Power BI documents.

Is there any way you can help me with this?

I have found a lot of different ways to extract metadata from Power BI, but they aren't automated and often not able to handel multiple Power BI documents at a time. 

Thanks !