Home

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
timus2001
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
Hi

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

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.

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?
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies