cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Zip file (having the same name as actual file) from web source not working

Hi All,

 

I am fairly new to Power BI and mainly relying on your tutorials (https://community.powerbi.com/t5/Desktop/Unzip-and-load-csv-from-web-error-quot-we-didn-t-recognize-...)

This solution works quite well, however, recently I encountered a Zip file which has multiple csv files and only one shows up after performing these steps and the Binary content is not readable...

 

When I download it and rename certain files, it works so I assume there is a naming issue, however, I can't figure out how to re-configure Mark White's much appreciated post...

I think I would have to change this part but I cannot figure out how: 

"each if _ <> 67324752 // not the IsValid number? then return a dummy formatter
then BinaryFormat.Record([IsValid = false, Filename="test", Content=null])"

 

And the url to the zip: https://vicroadsopendatastorehouse.vicroads.vic.gov.au/opendata/Road_Safety/ACCIDENT.zip

 

If you can give me to any direction, I really appreciate it 🙂

 

Cheers a lot, hope my question is in the correct form

ZJ

3 REPLIES 3
Highlighted
Super User IV
Super User IV

Re: Zip file (having the same name as actual file) from web source not working

What Connector are you using?


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Frequent Visitor

Re: Zip file (having the same name as actual file) from web source not working

Hi Greg,

 

I am using the Get Data -> Blank Query ->Advanced Editor and type in the code below where the UnzipContents is the function based on Mark White's blog

let
Source = Web.Contents("https://vicroadsopendatastorehouse.vicroads.vic.gov.au/opendata/Road_Safety/ACCIDENT.zip
"),
Files = UnzipContents(Source)
in
Files

 

cheers

Highlighted
Frequent Visitor

Re: Zip file (having the same name as actual file) from web source not working

Just a follow up: I could solve this using python which I cannot use in scheduling but nevertheless it's working

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021