Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Impactful Individual
Impactful Individual

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
Impactful Individual
Impactful Individual

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors