Forum Discussion
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-the/td-p/646849) Thi...
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
Just a follow up: I could solve this using python which I cannot use in scheduling but nevertheless it's working