Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to Solution.
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.
Hi @Priya2007
Have you solved this problem? If so, kindly accept an appropriate reply as Solution or post your own solution to help other people find the solution quickly. If not, please provide more information about it. Thanks.
Best Regards,
Community Support Team _ Jing
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.
Try adding a custom column that does the unzipping, and then performing combine on that new column.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.