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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors