Forum Discussion

sowmya2553's avatar
sowmya2553
Helper 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
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi sowmya2553 

please open properties for that folder, paste the path under "Location" in the "path" as below

let
    path = "C:\Users\maggiel\Desktop\case\6\6.28",

 

If your issue doesn't solve, please show me what's error you meet.

 

To upload picture here, please sign in with your Power BI Account here.

You could also upload file/screenshots to the OneDrive and share the link here.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

sowmya2553's avatar
sowmya2553
Helper I
7 years ago

 

Hi Maggie,

I have tried and still the same error.

 

Kindly verify screenshot.

 

Regards,

Sowmya

 

  • Dellis81's avatar
    Dellis81
    Post 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
      Helper 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.

       

  • sowmya2553's avatar
    sowmya2553
    Helper I
    7 years ago

    Any update on this further?

    • Dellis81's avatar
      Dellis81
      Post 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
        Helper 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.