Forum Discussion
Help with get data from "Web"
I'm new to scraping data from webpages. Is it possible to set up a "get data" for the following webpage?
| https://www.chooseenergy.com/shop/residential/electricity/NY/10516/new-york-state-electric-gas-ny-electricity/ |
Any special M needed? the "web view" preview displays what i'm looking for but in the table view i only see an empty table with one row. Any assistance in getting me started would be appreciated.
Thanks folks,
--Alfonso
Hi Anonymous,
>>is it possible to set up a "get data" for the following webpage?
I think it is impossible. power query not support to operate the pages script(javascript functions in page) to analysis the redirect url and switch the displayed data.
In my opinion, you should get data from the api url to instead of the current url.Regards,
Xiaoxin Sheng
2 Replies
Hi Anonymous,
>>is it possible to set up a "get data" for the following webpage?
I think it is impossible. power query not support to operate the pages script(javascript functions in page) to analysis the redirect url and switch the displayed data.
In my opinion, you should get data from the api url to instead of the current url.Regards,
Xiaoxin Sheng