Forum Discussion
Solved
Extract data from website
Hi everyone, I want to extract dividend data from the site dividendhistory. However, with underlying code, I am only able to extract a few rows instead of the whole table. And this stock has sever...
That site is loading data with JavaScript so unfortunately you can't use Power Query to get the data.
PQ requires that the data can be retrieved with parameters that are supplied in the URL (or possibly in headers). Unless the site API allows this you are stuck.
You could use somethign like Selenium to get the data but that requires further programming outside PQ.
There are webites that provide scraping as a service, you can search for them, but that will cost you and require integration into PQ.
Phil
J, I had a similar problem and I used Grok to give me the precise answer. It worked.
Try it yourself.