How do I unzip a zip file when a new or modified file is detected in Azure Blob Storage?

(1) Share

Report

Posted on by futr_vision

831 Moderator

Hopefully this is the right forum to ask this.

Here is my situation. I have a file that is being written to an Azure Blob Storage container on a regular basis. This file, unfortunately, can only be delivered zip due to its size. I want to use the CSV stored in the zip file in PowerBI however PowerBI can not natively read a zip file. What I am looking for is a way to maybe use PowerAutomate to look for new or modified blobs (looks like there is a trigger for that) and, if it finds one, unzip the file right there in the Blob Storage container. Is there a way to do this? I am not finding any actions the explicitly say they perform this function. Perhaps I need to move the file to another location first where PowerAutomate has an action to unzip a file and then transfer that file back to Blob Storage.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

One recommended "easy path" is to leverage Power Automate for Desktop. While is seems like a band aid, some of these tools will run flawlessly for years. Check this out!

Add a Run a Flow Built in Power Automate Desktop action in your cloud flow.

Create a Power Automate Desktop flow to:

Save the ZIP file to a local directory.

Use the Extract archive to folder action in Power Automate Desktop to unzip the file.

Upload the extracted files back to Azure Blob Storage using Upload file to Azure Blob Storage.

------------------------------------------------

⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hey there!

I am following up on this post how do i unzip a zip file when a new or modified file is detected in azure blob storage? in this category general discussion from 01/16/2025. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 1 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report

I need something that is automated.

Was this reply helpful? Yes No