Azure Blob Usage Analytics

[willis78]

Hi All

I am trying to connect to Azure Blob storage to extract the storage metrics but for the life of me it just doesn't work. I have connected via the Azure Blob connector and am able to extract the contents of the Blob storage but I would like to pull the usage analytics data such as used space.

I understood that Blob storage has tables that could be queried for transaction and capacity (https://docs.microsoft.com/en-us/rest/api/storageservices/about-storage-analytics-metrics).

Does anyone know how to extract this data? or can point me in the right direction or an article that can help.  I've come across suggestions on extracting data from Table storage (https://blogs.endjin.com/2015/04/visualise-your-azure-table-storage-data-with-power-bi/) but I understand this to old (and doesn't work for me).

Any help would be much appreciated. 

Thanks

Pete

[v-yuezhe-msft]

@willis78,

Based on my research, we are not able to get Azure Blob storage metrics via the storage connector in Power BI Desktop, an idea about this issue has been submitted in this link, please vote it up.

Regards,