Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey,
I'm working with tar.gz from a public FTP directory. The problem is I'm having trouble getting the file contents into PowerBI. For a single .tar.gz file, I am able to decompress:
Binary.Decompress(File.Contents("File path on local drive"), Compression.GZip))
The trouble is, I am left with a .tar file, which contains 1500-2500 XML files. I can convert this file into a csv document or text file but it's not really useful.
Does anyone have any idea how to go forward from here?
The tar.gz files are form here (public data): ftp://ted.europa.eu/daily-packages/2018/06/
Credentials: guest & guest
Hi @Anonymous,
Here are some similar threads for your reference:
Decompress and load multiple .gz files from multiple folders
Binary.Decompress() and zip files
Regards,
Yuliana Gu
Hi @v-yulgu-msft,
Thanks for the links!
I went through the references but the trouble is there isn't any information on how to work with a tar archive. I am successful in decompressing the gzip but then I'm left scratching my head with the tar archive.
Is there any way to work with tar archives in Power Query?
Regards,
Tuomas