Taylor Clark on 12 Feb 2015 09:22:39
Allow me to browse and read from a zip file
- Comments (6)
RE: Read from zip files
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
RE: Read from zip files
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).
RE: Read from zip files
Open CSV zipped files could be very useful.
RE: Read from zip files
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
RE: Read from zip files
Maybe this can help you
http://www.excelandpowerbi.com/?p=155
RE: Read from zip files
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.