Gent data from pdf on website

[Arslan_Hanif]

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.

[#2]

Hi @Arslan_Hanif 

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

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