Forum Discussion
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). ...
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?
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?