Forum Discussion

Sachin Jain's avatar
Sachin Jain
Brass Contributor
Jun 20, 2018

Data does not load after query

Hello everyone,

I tried to scrap the share price from Money Control website 

Link :  https://www.moneycontrol.com/india/stockpricequote/cigarettes/itc/ITC

And with Web.Page, i am able to reach the value in power query editor, but when i load , it does not load in excel. Sometime error on load includes expression error and sometime load time error 

 

Please suggest the solution 

 

M Code that you can test 

 

let
Source = Web.Page(Web.Contents("https://www.moneycontrol.com/india/stockpricequote/cigarettes/itc/ITC")),
Data8 = Source{8}[Data],
Children0 = Data8{0}[Children],
Children1 = Children0{1}[Children],
Children41 = Children1{41}[Children],
Children4 = Children41{4}[Children],
Children2 = Children4{0}[Children],
Children = Children2{25}[Children],
Children3 = Children{1}[Children],
Children5 = Children3{12}[Children],
Children6 = Children5{1}[Children],
Children7 = Children6{0}[Children],
Children8 = Children7{1}[Children],
Children9 = Children8{0}[Children],
Children10 = Children9{0}[Children],
Text = Children10{0}[Text],
#"Converted to Table" = #table(1, {{Text}})
in
#"Converted to Table"

 

 

Please suggest 

 

 

 

No RepliesBe the first to reply

Resources