Error in extracting data from the web using Power Query

%3CLINGO-SUB%20id%3D%22lingo-sub-325485%22%20slang%3D%22en-US%22%3EError%20in%20extracting%20data%20from%20the%20web%20using%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-325485%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20new%20to%20power%20query%20and%20am%20using%20the%20GUI%20based%20method%20to%20bring%20data%20from%20a%20webpage%20onto%20my%20excel%20(i.e.%20I%20am%20not%20an%20expert%20in%20M%20and%20might%20not%20be%20able%20to%20understand%20the%20advanced%20editor).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20dot%20it%20the%20way%20it%20is%20explain%20in%20this%20video%3A-%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FConnect-to-a-web-page-Power-Query-b2725d67-c9e8-43e6-a590-c0a175bd64d8%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FConnect-to-a-web-page-Power-Query-b2725d67-c9e8-43e6-a590-c0a175bd64d8%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEven%20though%20I%20am%20able%20to%20see%20the%20data%20in%20on%20the%20edit%20page%2C%20I%20see%20the%20following%20error%20at%20the%20last%20step%20%3A-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22The%20Column%20%22column%201'%20of%20the%20table%20wasn't%20found.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20extract%20data%20from%20the%20following%20link%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.nseindia.com%2Flive_market%2FdynaContent%2Flive_watch%2Fequities_stock_watch.htm%3Fcat%3DSGB%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.nseindia.com%2Flive_market%2FdynaContent%2Flive_watch%2Fequities_stock_watch.htm%3Fcat%3DSGB%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anybody%20please%20help%20in%20resolving%20the%20error%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-325485%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327010%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20in%20extracting%20data%20from%20the%20web%20using%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327010%22%20slang%3D%22en-US%22%3EHi%20%3CBR%20%2F%3EInteresting%2C%20I%20don't%20see%20how%20it%20worked%20in%20the%20first%20place%2C%20unless%20the%20data%20structure%20on%20the%20website%20has%20changed.%20I%20tested%20out%20accessing%20the%20data%20using%20Power%20Query%20in%20Power%20BI%20and%20it's%20easier%20but%20not%20easy.%20You%20have%20to%20drill%20down%20to%20around%20the%2017th%20Child%20level%20to%20get%20to%20the%20data.%3CBR%20%2F%3E%3CBR%20%2F%3EWas%20it%20this%20same%20webpage%20the%20original%20query%20came%20from%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326269%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20in%20extracting%20data%20from%20the%20web%20using%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326269%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20shows%20the%20'column%201'%20error%20when%20I%20try%20to%20refresh%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20it%20is%20a%20bit%20strange%2C%20as%20today%20I%20am%20seeing%20some%20data.%20At%20the%20time%20when%20I%20placed%20my%20original%20request%2C%20I%20could%20see%20the%20error%20message%20only.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-325527%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20in%20extracting%20data%20from%20the%20web%20using%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-325527%22%20slang%3D%22en-US%22%3EHi%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20you%20post%20your%20file%20for%20me%20to%20take%20a%20look%3F%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

 

I am new to power query and am using the GUI based method to bring data from a webpage onto my excel (i.e. I am not an expert in M and might not be able to understand the advanced editor).

 

I dot it the way it is explain in this video:-

https://support.office.com/en-us/article/Connect-to-a-web-page-Power-Query-b2725d67-c9e8-43e6-a590-c...

 

Even though I am able to see the data in on the edit page, I see the following error at the last step :-

 

"The Column "column 1' of the table wasn't found.

 

I am trying to extract data from the following link

https://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm?cat=SGB

 

Can anybody please help in resolving the error

3 Replies
Highlighted
Hi

Can you post your file for me to take a look?
Highlighted

It shows the 'column 1' error when I try to refresh it.

 

Also it is a bit strange, as today I am seeing some data. At the time when I placed my original request, I could see the error message only.

Highlighted
Hi
Interesting, I don't see how it worked in the first place, unless the data structure on the website has changed. I tested out accessing the data using Power Query in Power BI and it's easier but not easy. You have to drill down to around the 17th Child level to get to the data.

Was it this same webpage the original query came from?