Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Pulling in a web source that prompts for zip code

Hello!   I am trying to reference a table on a website that is only accessible after entering in a zip code (so the site can display the correct information based on zip). Does anyone know how to p...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Anonymous 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.⚡

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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!