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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors