Forum Discussion

Priya2007's avatar
Priya2007
Frequent Visitor
4 years ago
Solved

unzip files from email

Hi , I am trying to unzip files from an email. In zip folder I have two files one is csv and other is xlsx. I am getting below error: If anyone can help would be great.     Regards,
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Priya2007 

     

    You can create a custom function with M code from this blog  Reading Zip files in PowerQuery / M, then add a column to your current table by invoking this function (Add column tab > Invoke Custom Function). You will have a table content in the new column. After expanding the table, you will see all files in this zip folder and you can access either one you want. 

     

    Here is a video tutorial for it: Get data from zip files without extracting them in Power Query - YouTube

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Priya2007 

 

You can create a custom function with M code from this blog  Reading Zip files in PowerQuery / M, then add a column to your current table by invoking this function (Add column tab > Invoke Custom Function). You will have a table content in the new column. After expanding the table, you will see all files in this zip folder and you can access either one you want. 

 

Here is a video tutorial for it: Get data from zip files without extracting them in Power Query - YouTube

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.