Forum Discussion

Sachin Jain's avatar
Sachin Jain
Brass Contributor
Apr 23, 2017
Solved

Get Data from Web

Hello   LInk : http://rajasthanindustries.org/ViewCompanyProfile.aspx?id=All&typet=alpha   There is a dataset which I want to get and transform using web, its in table but not able to identify , ...
BI & Data Analytics
Get & Transform Data
  • SergeiBaklan's avatar
    SergeiBaklan
    May 11, 2017

    Yury, in general that's possible, in the code you have you have to use instead of Web.Page(Web.Contents(...)) just only Web.Contents(...) and after that parse the code more or less manually. I did that to extract some information from this Tech Comm site.

     

    One of the examples for such approach is http://datachant.com/2017/05/08/web-scraping-power-bi-part-2/, the latest i've seen, but Gil published more on his site.

     

    However not sure that's practical for this concrete case.

Yury Tokarev's avatar
Yury Tokarev
Iron Contributor
May 10, 2017

Hi Sachin,

 

I am not an expert in websites, however, as far as I have heard, if 'Document' is the only item you see in the 'Navigator' menu when connecting to a website (so there are no other tables visible), the website is likely to be using Java Script. This makes it highly unlikely that you will be able to extract any useful information from it. Apparently, this issue is being worked on by Microsoft.

 

Yury

Resources