Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Create Custom.Column to open rar file in query

Hi,

 

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

I wanna get excel sheet in them. 

 

 

General Comment
Need Help
Show and Tell
Tips and Tricks

2 Replies

  • freginier's avatar
    freginier
    Icon for Solution Sage rankSolution Sage
    1 year ago

    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 

    😅

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, Anonymous 

    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.