Gent data from pdf on website

Occasional Visitor

Hello all,

 

I need to get data from website using power query. However data is uploaded on website on daily basis in pdf file which need to be downloaded. Is it possible to get data from downloadable pdf file from website.

Please guide.

Regards.

1 Reply

Hi @Arslan_Hanif 

 

#1 - It mainly depends on how the Webpage is setup. Take the example of https://www.msn.com/en-us:

_Screenshot.png

The page doesn't consist of any Table but an HTML doc. where a nested [Children] Table exists. However, the latter consists of nested tables that consist of nested tables... Almost mission impossible to find what you want...

 

#2 - Does your version of Excel has Power Query function Pdf.Tables?
==> See Power Query / Get & Transform – Get data from PDF missing