cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Mapping IP Addresses Example

Hi!


I am trying to map ip addresses on Power BI.

I have referenced both of these (and a couple other articles):

https://community.powerbi.com/t5/Desktop/IP-address-mapping/td-p/138436

https://community.powerbi.com/t5/Desktop/IP-address-mapping-and-privacy-levels/td-p/224109

 

Here is a very simplified version of my data:

ip_example.PNG

 

 

1. I create a custom function:

 

 

	let
    Source = (#"IP Address" as text) => let
        Source = Json.Document(Web.Contents("http://freegeoip.net/json/" & #"IP Address")),
        #"Converted to Table" = Record.ToTable(Source),
        #"Transposed Table" = Table.Transpose(#"Converted to Table"),
        #"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table")
    in
        #"Promoted Headers"
in
    Source

 

2. I try to invoke the function and get this error:

 

"Formula.Firewall: Query 'New Students' (step 'Invoked Custom Function') is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination.

 

3. I tried to reference this article to fix the problem (https://blog.crossjoin.co.uk/2017/06/26/data-privacy-settings-in-power-bipower-query-part-3-the-form...), but I am a DAX dummy and cannot apply it…

 

Can someone please give me an example of how to properly call this custom function and mapping the IP addresses?

 

PS - My data is private and I cannot change it to public.

Thank you!!

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Mapping IP Addresses Example

Hi @mk720x ,

 

If your data is confidential, the mapping address function is not a effective solution because it will send ip to the api to get the address. So You can try to import a full version of geo ip database into Power BI, and combine with your data in Power Query Editor.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper III
Helper III

Re: Mapping IP Addresses Example

@v-lid-msftthanks for the reply!

I was exploring and thought perhaps I could use this to get the country geolocation.
The file is a SQL file... how could I use this in Power BI?

 

http://www.ip2nation.com/ip2nation

 

Thank you!

Highlighted
Community Support
Community Support

Re: Mapping IP Addresses Example

Hi @mk720x ,

 

We can import the sql file into a SQL Server then use the Power BI to connect it, or just export it as a excel and import it into Power BI.

 

Or you can download GeoLite2 Country database with a csv format from maxmind and import it into the powerbi.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors