Allow me to browse and read from a zip file
7 Comments
- 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.
- Maybe this can help you http://www.excelandpowerbi.com/?p=155
- 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
- Open CSV zipped files could be very useful.
- 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).
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
- Status added:Needs Votes
Recent ideas
Support Automatic Connection Variable Mapping for Lakehouse Shortcuts Across Deployment Pipelines
When using Deployment Pipelines to promote Lakehouses containing shortcuts that use Delegated Identity, the connection variables defined through a Variable Library are not consistently retained or au...
