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

(0) 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:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Power Automate has an action that can unarchive (unzip) a file to a OneDrive for Business folder. You can use that to get the file and then pass it to Power BI.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

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

Like (0)

Report

I've come across those actions. That is a consideration, but it does introduce additional points of failure.

Was this reply helpful? Yes No