Share via

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

Shivendoo Kumar 751 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
Azure Storage
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,538 questions
0 comments
Accepted answer
  1. Shivendoo Kumar 751 Reputation points
    2020-08-07T05:13:20.473+00:00
    2 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. deherman-MSFT 38,021 Reputation points Microsoft Employee Moderator
    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.