Best way to connect Power BI to Azure and count all files in all storage of specific resource group?

[PunchBird]

Hi all,

What is the most pragmatic and cost-effective method to connect Power BI to Azure and extract data in all Blob storage containers of a specific resource group? The purpose is that I need to count all files of a specific type in all Blob storage containers of that specific resource group. I know how to connect to one Blob storage, but there are many and the number keeps growing so I need a dynamic approach.

Thanks!

[v-binbinyu-msft]

Hi @PunchBird ,

I'm a little confused about your needs, Could you please explain them further? 

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_ Binbin Yu

[PunchBird]

I wish to query the Azure Blob storage account to count the number of containers and count the number of documents of a specific type in each container, and then ingest the results of these counts daily via Power BI (import mode). What is the easiest, most pragmatic and cost-efficient way to do this?