Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DataLife321
Frequent Visitor

Azure blob storage - Show deleted Blobs

Hi All, 

 

Has anyone connected to an Azure Storage Blob before in Power BI and managed to retrieve a list of the 'Show deleted blobs' as well as the active files ? 

DataLife321_0-1708609721662.png

 

If you have this would be great to know as I need to create a report based off a container which shows the Status of the active files and would like to filter to ones that may of been deleted aswell. 

 

thanks 

1 REPLY 1
v-yifanw-msft
Community Support
Community Support

Hi @DataLife321 ,

To achieve the goal, you need to ensure that the soft delete feature is enabled on Azure Blob Storage. This feature keeps deleted Blobs (and their versions and snapshots) for a period of time so that they can be restored when needed. Once soft deletion is enabled, these deleted Blobs can be viewed and managed using the Azure portal. see the Azure documentation for detailed steps on enabling and managing soft deletion:

Soft delete for blobs - Azure Storage | Microsoft Learn

However, to integrate this data into Power BI, the process is not as simple, as Power BI's Azure Blob Storage native connector does not directly support filtering or displaying deleted blobs. the following are suggested ways to work around this limitation:

  1. You might consider creating an Azure function that accesses the Blob Storage, lists the active Blobs and deleted Blobs, and then outputs this data to a location accessible to Power BI, such as an Azure SQL database or other Blob container set up for this purpose.
  2. Once you have the Azure function set up and running, you can use Power BI to connect to the database or Blob container from which the function exports Blob data. From there, you can import the data into Power BI and create reports, including filtering on active and deleted blobs as needed.

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors