Forum Discussion
Trying to extract files from ZIP
I am trying to load the ZIP file in power BI through below query but it throws the error “We didn’t recognizes the format of your first file (). Please filter the list of files so it contains only su...
Hello, I am having the same issue using the same MarkWhite function, with the exceptions of xlsx files. Once I get past this hurdle, each file within the zip file has same name, and then each file has 4 unique tab names. Will I be able to filter and extract same as a single file? Appreciate advice and a solution. Thanks!
Hi there,
Once you extract the files from Zip, you can select all the worksheet names that you want to load in power BI.
You can use the append query option (but ensure you have the same column names in all sheets) so that it will append in power query.