Forum Discussion
Pulling in a web source that prompts for zip code
Super UserAnonymous once you enter the zip code it probably adds that a query parameter in the URL, can you get that URL from the browser and then use that as a starting point, concatenate the zip code from Power BI in the URL, and pull the data.
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Thanks parry2k -- I'm not sure if that's what's happening. Here's an example of a site where you're prompted for state and the URL does change once you've chosen a state: https://www.usbank.com/home-loans/mortgage/mortgage-rates.html
My source is more like this where the URL doesn't change (and concatenating the zip at the end doesn't load the page successfully): https://www.bankofamerica.com/deposits/bank-cds/cd-accounts/
I'm not super savvy with web so sorry if I'm misunderstanding or overlooking something simple!