Jan 25 2019 02:23 AM
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:-
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
Jan 25 2019 04:09 AM
Jan 27 2019 06:09 AM
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.
Jan 28 2019 08:15 PM