Forum Discussion
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...
Hi there,
If you can change the double quotes to be ", as due to the copy and paste they are the italic double quotes
= Table.AddColumn(#"Changed Type1", "ParkRun", each Function.InvokeAfter(()=>fx_ParkRunData([Run]), #duration(0,0,0,#"Refresh Interval")))
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?
- Hi there
I think it might then be a limit on the site in terms of how many free IP Addresses you can geocode?- 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?
- 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.