I have a problem with uncompressing files online type *.7z...
The URL is this: https://cloud.minsa.gob.pe/s/g9KdDRtek42X3pg/download
My problem is to unzip the file from the same power bi, to create a direct connection with the link. because the information inside the *.7z file is updated every day.
Note: When you download this file. You can see that is a file *.7z and content a file *.csv.
I tried with a function in power bi for file type *.zip but I do not result it.
Thanks for your time.
HI @NantoCaparachin ,
I googled a bit and found a post regarding unzip in Power BI:
Working With Zip Files in Power Query - Microsoft Power BI Community
Hi @NantoCaparachin ,
I am 100% sure I understood your problem.
Sorry, but I need uncompressing with Power Bi because the information is updated every day. Not only unzip the file from the pc.
Have you thought of using Power Automate to uncompress the zip file instead?
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.