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.