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
I have a blog post coming out later today (Australian time) where I explain how to use a different IP Address Lookup with a way to limit how quickly it will query the API.
You can find it here: https://www.fourmoo.com/blog
I have a blog post coming out later today (Australian time) where I explain how to use a different IP Address Lookup with a way to limit how quickly it will query the API.
You can find it here: https://www.fourmoo.com/blog
Will try this method hopefully it works and if it does, I owe you a virtual glass of champagne.
- Please let me know if it works.
Looking forward to that virtual glass of champagne= Table.AddColumn(#”Changed Type”, “fn_GetIPAddressDetails”, each Function.InvokeAfter(()=>fn_GetIPAddressDetails([IpAddress]), #duration(0,0,0,#”Interval (Secs)”)))
So i paste in the above code as your step says over the Invoked function column. But I get the error "Invalid Literal"
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")))