Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

mass ip geolocation

Hey PowerBI,    I'd like to conduct a mass look up of all IP addresses within my file providing them with associated latitudes and longitudes so I can accurately locate where they map out to.  I ha...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hey GilbertQ, No worries I got it working. Takes a pretty long time but thats expected I have 4.3k Ip Addresses. Not sure if my issue is with the API service or not now because there is a limit. But I will come up with an issue that says "access to the resource is forbidden" with the url of the website "http://api.ipstack.com/[IpAddress]". This is the same issue I faced previously when using the API and seems the InvokeAfter.Function won't do the job.... 

 

Any other ideas? 

GilbertQ's avatar
GilbertQ
Super User
8 years ago
Hi there

I think it might then be a limit on the site in terms of how many free IP Addresses you can geocode?
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago
    So I’ve spoken to them and they said that it’s an issue with Power BI itself. The Lead analyst at ups tack said there wasn’t a request limit on my service. Any ideas from tech?
  • GilbertQ's avatar
    GilbertQ
    Super User
    8 years ago
    Hi there,

    I have done Geocoding over a larger dataset without any issues.

    I would ask them to explain what is the error and why it is happening. It appears to me that they are just saying it is a Power BI issue without proving anything.
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Yeah I guess so too. I've sent another email to them and will see what they come back with. This is all pretty frustrating, I just need can't seem to find enough API services without "https" to allow me to acccess their databases via API as opposed to buying expensive databases.