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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors