Need name of list of .bak Files (Metadata of Files) from Azure Blob Containers..?

Shivendoo Kumar 736 Reputation points
2020-08-03T06:16:40.36+00:00

Hi All,

I have a Blob Container on Azure and This container has Block Blobs (Database Backups). There are more than 100 files and I want to create a report (SSRS or POWERBI) to show list of File Names, Blob Type, Access Tier, File Size, Date Created, Date Modified etc.

How can I pull above metadata of all the files.

Any suggestions? I am ok with using Poly-base, or pulling these information using SSIS or if there is any way I can get these info using PowerBI?

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,871 questions
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. deherman-MSFT 34,931 Reputation points Microsoft Employee
    2020-08-03T17:23:45.013+00:00

    @ShivendooKumar-8455 According to this thread you cannot directly use the Azure blob storage connector for PowerBI as it will also download the file contents. They recommend using the Blob Rest API and then using that as a data source. You might find this page useful if that is the direction you choose to take.

    Hope this helps!

    Please don’t forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.