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
rahkim's avatar
rahkim
Icon for Helper I rankHelper I
6 years ago

This is a few months old, but I thought I would chime in.  I'm curious if you get the warning from Excel when you open your file that says the file format and extension don't match.  HTML wrapped in an xls extension can cause this.  If you open the .xls file in your zip and then save as an .xls then it will probably work.  But since that is not feasible to do every time you may want to update your registry or  Trusted Center locations so that you don't get the warning any more.  

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

    Thank you for your suggestion.   Yeah, this was a few months ago, but I will revisit and see how much rework I will need to do to test this idea.   But, I do recall, given data limitations within the excel files, I have to manually modify the file name (with a date) to get things dated correctly.  So, I have to "touch" the files anyway - so I kinda gave up on hte idea of pulling from the initial zip file.

     

    But, I will definitely keep this in mind - as things continuely evolve.

    thanks