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

 

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

Any update on this further?

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

    No, not really.  Ended up utilizing a zip utiliity that allows autonaming of unzipped files.  From there, I went down the power query option of connecting to a folder, that pulls in all files from said folder.

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

      Can you please guide me how did you do that?

      I am not fully understanding..

      Dellis81 wrote:

      No, not really.  Ended up utilizing a zip utiliity that allows autonaming of unzipped files.  From there, I went down the power query option of connecting to a folder, that pulls in all files from said folder.