Forum Discussion

chrisBLVD's avatar
chrisBLVD
Frequent Visitor
5 years ago
Solved

Forward Geocoding within Power BI

All,   New to Power BI and having the following difficulty. I have about a dataset (being pulled from google sheets) of about 140k addresses. I'd like to show these points on either a mapbox or bin...
Need Help
Tips and Tricks
Tutorial Requests
mpicca13's avatar
mpicca13
Icon for Resolver IV rankResolver IV
5 years ago

chrisBLVD  try this video, this guy uses bing maps to get lats and longs from addresses: https://youtu.be/YxwU5UubWjI

 

Please accept this as a solution if this helped.

  • chrisBLVD's avatar
    chrisBLVD
    Frequent Visitor
    5 years ago

    mpicca13 Wow thanks! Works great. Only issue now is that the solution takes quite a while to loop through all 140k rows. This is fine for a single run, but running this every time a refresh occurs is bound to take ~12hrs to loop through all data. 

    Do you know of a way to apply this solution to only newly entered data upon refresh? If this requires a new thread, happy to create one.