Forum Discussion
Unzip file containing zip files
I have been able to successfully get the contents of zip files using this query from Mark Whites Blog.
However, this does not appear to work when applied to a zip file that contains multiple zip files itself. In this case it only seems to obtain one of the contained files.
I am assuming this is somehow caused by the following condition (and subsequent filter on IsValid):
if _ <> 67324752 // not the IsValid number? then return a dummy formatter
then BinaryFormat.Record([IsValid = false, Filename=null, Content=null])
Any ideas on what is happening and how to fix?
Thanks!
2 Replies
- v-jialluo-msft
Community Support
Hi Anonymous ,
Through your description, you need to read the ZIP archive directly in PowerBI, you can refer to the methods in the following link to achieve your purpose.
Working With Zip Files in Power Query - Microsoft Power BI Community
Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- AnonymousNot applicable
I've tried to use the function from this blog but get the following error and not sure what is causing it:
"An error occurred in the ‘’ query. Expression.Error: We cannot convert a value of type Binary to type Text.
Details:
Value=[Binary]
Type=[Type]"