Read from zip files

[TaylorClark]

Allow me to browse and read from a zip file

[yoshihiro]

A lot of zip files are published by Government's web site in Japan. These zip files include Excel files, CSV files. Some zip files have folders in it. I want to use Excel/CSV files as Power BI' "Web" data source, to no-download/no-expand/updatable these files.

[andrea_brambill]

Maybe this can help you http://www.excelandpowerbi.com/?p=155

[stefan_quinn2]

Create a function using the code here http://sql10.blogspot.com.au/2016/06/reading-zip-files-in-powerquery-m.html Then to iterate over the files on the web page, do something like let GetCSVContents = (data) as table => let files= unzipFile(data[Content]), csv=Csv.Document(files[Content],[Delimiter=",", Columns=10, Encoding=1252, QuoteStyle=QuoteStyle.None]) in csv, f=unzipFile(Web.Contents("http://blah.com")), combine=Table.AddColumn(f,"Contents",each GetCSVContents(_)) in combine

[jcaubin1]

Open CSV zipped files could be very useful.

[fbcideas_migusr]

Not just locally, but an online one as well to allow for automatic refreshing (like the web connector does with a table in a website).

[fbcideas_migusr]

Agreed.

It would be nice to have native tools for unzipping files that contain multiple data files into a DataLake for further ETL processing with pipelines. This would allow users to download, unzip, process (ETL) and consume data using an automated end-to-end process.

Thanks