Data Source Settings not showing my full list of downloads

[paulrothman]

The first screenshot is my PowerBI desktop app when I click "Transform Data" -> "Data Source Settings". 

PowerBI only shows me 5 random downloads from my downloads folder. 

I need to connect the zip folder downloads for "Overdue", "RAG Status", and "Priority Status".

Any advice? 

Thank you in advance.

[v-yingjl · Accepted solution]

Hi @paulrothman ,

Folder connecto only distinguish normal folders instead of .zip format. If you want to connect to .zip files in power bi, you can try to use power query. Please refer this blog and these threads:

1. Reading Zip files in PowerQuery / M 
2. Trying to extract files from ZIP 
3. PowerQuery read from folder with many zip file 

Basically the query is like this:

let
path = "Path\Zipfolder",
Source = Folder.Files(path),
#"Filtered Rows to only .zip" = Table.SelectRows(Source, each ([Extension] = ".zip")),
#"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows to only .zip",{"Content"}),
#"Added Custom UnzipContents" = Table.AddColumn(#"Removed Other Columns", "Custom", each UnzipContents([Content]))
in
    #"Added Custom UnzipContents"

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

[PhilipTreacy]

Hi @paulrothman 

You should extract the contents of the ZIP files then use the Folder connector or File connector to load what you need from within a query, rather than going through the Data Source Settings dialog.

You culd open th ZIP's but it's not easy - refer to this https://community.powerbi.com/t5/Community-Blog/Working-With-Zip-Files-in-Power-Query/ba-p/1190186

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.