Forum Discussion

sowmya2553's avatar
sowmya2553
Icon for Helper I rankHelper I
7 years ago

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...
Need Help
sowmya2553's avatar
sowmya2553
Icon for Helper I rankHelper I
7 years ago

 

Hi Maggie,

I have tried and still the same error.

 

Kindly verify screenshot.

 

Regards,

Sowmya

 

Dellis81's avatar
Dellis81
Icon for Post Prodigy rankPost Prodigy
7 years ago

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!

  • sowmya2553's avatar
    sowmya2553
    Icon for Helper I rankHelper I
    7 years ago

    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.