Forum Discussion
Validate home address data
Dear Community,
I was curious to ask if someone know if Power BI has the option to validate a big data of home addresses if provided street name, suburb, state and country.
Example 1 row is
Street name: 44 Quay Street
Suburb: Coggee
State: NSW
Country: Australia
and Power BI will let me know if this address exist (or even match close home address if i had a spelling mistake)
Thank you in advance :)
I was curious to ask if someone know if Power BI has the option to validate a big data of home addresses if provided street name, suburb, state and country.
Example 1 row is
Street name: 44 Quay Street
Suburb: Coggee
State: NSW
Country: Australia
and Power BI will let me know if this address exist (or even match close home address if i had a spelling mistake)
Thank you in advance :)
1 Reply
Alex -
I'm not aware of any way that PowerBI will do this work for you. However, there are many 3rd party services that will perform the validation for you and you can call those APIs from your system of choice including PowerBI.
A quick search for "address validation in excel" (if you can do it in excel you can certainly do it in PowerBI) came back with:
https://www.youtube.com/watch?v=PvBSI_54pDk
https://appsource.microsoft.com/en-us/product/office/WA104379217?tab=Overview
https://smartystreets.com/products/list
I have not personally vetted any of these although I have used Melissa Data in the past to do this.
Hope that helps!
Eric
