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
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

PLease qualify what you mean by "issue".  Where are you stuck?

 

Here is the boilerplate code that works for me

 

let
    Source = Unzip(Binary.Buffer(Web.Contents(URL))),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"FileName", "Content"}, {"FileName", "Content"})
in
    #"Expanded Column1"

 

You can get the Unzip function from here: Solved: Re: How to connect Azure DevOps REST API in to pow... - Microsoft Fabric Community