Forum Discussion

timus2001's avatar
timus2001
Copper Contributor
Jan 25, 2019

Error in extracting data from the web using Power Query

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-c0a175bd64d8

 

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

excel
power bi

3 Replies

    • timus2001's avatar
      timus2001
      Copper Contributor
      Jan 27, 2019

      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.

      • Wyn Hopkins's avatar
        Wyn Hopkins
        MVP
        Jan 29, 2019
        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?

Resources