Forum Discussion

Rebecca6634's avatar
Rebecca6634
Frequent Visitor
4 years ago

Opening zipped Excel file from web url

I'd like to import the zipped Excel file into Power BI from this website:   https://www.ons.gov.uk/peoplepopulationandcommunity/housing/datasets/hpssadataset2medianhousepricebymsoaquarterlyrollingy...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Rebecca6634 ,

 

I have tried to firstly download the .zip file and followed the tutorial video

 

 

1. Create a Blank query, paste the code in the blog you provided.

 

2. Get data from Folder to connect the .zip file. Then add a Invoke Custom column:

 

3. After removing other columns, expand the "Binary" type column, such error occurs as lbendlin mentioned.

 

 

So finally you need to unzip the file and Get data from Excel to get tables instead.

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Rebecca6634's avatar
Rebecca6634
Frequent Visitor
4 years ago

Hi Eyelyn

 

Thanks for your reply. The zip file on the website updates regularly so ideally I want to connect and use the zip file directly from the website, without having to manually download a local copy to my machine. My report uses an automated refresh to stay up to date with the latest data so I need to avoid the step which requires me manually download the file.

Please could you advise if there is a way to do this?

 

Many thanks