Create Custom.Column to open rar file in query

[jeongkim]

Hi,

Can we make Table under Custome column to expand its excel data inside of .rar?

I wanna get excel sheet in them. 

[Anonymous]

Hi, @jeongkim 

Please refer to the article on the forum blog below to learn how to read compressed files in Power query

Working With Zip Files in Power Query - Microsoft Fabric Community

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[freginier]

Hey there!

Unfortunately, Power Query does not support extracting .RAR files directly. Excel.Workbook() only works with Excel files, but .RAR is a compressed format that Power Query cannot natively decompress.

Sorry this doesn't help 

😅