Forum Discussion
sowmya2553
Helper I
Helper ITrying 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...
Dellis81
Post Prodigy
Post ProdigyHello, 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!
sowmya2553Helper I
Helper IHi 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.