Help with get data from "Web"

[Anonymous]

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-el...

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

[Anonymous · Accepted solution]

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

[Anonymous]

Thanks, v-shex-msft! 

Can you (one anyone) point me to a good page to get started with api URL'ing??

Thanks, love this PBI community. Makes the product even more powerful. 

--fonz