Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |