Get Data, a Excel Doc located on a webpage

[Kristan]

Hi all,

I am trying to import an excel file located on a web page. At the moment I am saving the excel doc and loading into Power BI.

Is there any way I can import this directly from the webpage?

Thank you in advance!

http://www.abs.gov.au/AUSSTATS/abs@.nsf/DetailsPage/6427.0Dec%202017?OpenDocument

[v-yuta-msft]

Hi Kristan,

To achieve your requirement, please follow steps below:

1.Open this website, right click on the excel icon, then click inspect.

2.Right click on the html element below, then click Copy link address.

3.Open power bi, click Get Data->Web,  paste link address here and click OK.

 

The result is like below:

 

Regards,

Jimmy Tao

[Kristan]

Thanks Jimmy, could you paste the full html element? I must be doing something wrong, the results I get are:

http://www.abs.gov.au/ausstats/meisubs.NSF/log?openagent&642701.xls&6427.0&Time Series S...

[v-yuta-msft · Accepted solution]

Hi Kristan,

Are you using chrome or firefox? I recommend you to use browser with development tools to achieve the link address.

Regards,

Jimmy Tao

[Kristan]

That worked, I opened the site in Chrome, right clicked on the file and slected "copy link address"

Thanks for all your help