cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NantoCaparachin
Frequent Visitor

TRY TO EXTRACT FILE ON LINE *.7Z

Hi, community, 

 

I have a problem with uncompressing files online type *.7z... 

 

The URL is this: https://cloud.minsa.gob.pe/s/g9KdDRtek42X3pg/download

 

NantoCaparachin_0-1656709365528.png

 

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. 

 

NantoCaparachin_0-1656709847085.png

 

I tried with a function in power bi for file type *.zip but I do not result it.

 

 

Thanks for your time.

 

4 REPLIES 4
KT_Bsmart2gethe
Super User
Super User

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
Super User
Super User

Hi @NantoCaparachin ,

 

I am 100% sure I understood your problem.

 

KT_Bsmart2gethe_0-1656722067473.png

 

 

Regards

KT

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

 

Thanks

Hi @NantoCaparachin ,

 

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


Regards

KT

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors
Top Kudoed Authors