TRY TO EXTRACT FILE ON LINE *.7Z

[NantoCaparachin]

Hi, community, 

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.

[KT_Bsmart2gethe]

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

Regards

KT

[KT_Bsmart2gethe]

Hi @NantoCaparachin ,

I am 100% sure I understood your problem.

Regards

KT

[NantoCaparachin]

Sorry, but I need uncompressing with Power Bi because the information is updated every day. Not only unzip the file from the pc.

Thanks

[KT_Bsmart2gethe]

Hi @NantoCaparachin ,

Have you thought of using Power Automate to uncompress the zip file instead?

Regards

KT