Open Side Menu
Skip to contentBrand Logo
Forums
Inspiration
Ideas
Communities
Blogs
Learning
Support
RegisterSign In
  1. Microsoft Fabric Community
  2. Power BI forums
  3. Galleries
  4. Data Stories Gallery
SamLester's avatar
SamLester
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

IP Address Mapping in Power BI

The following report and M code show how to perform an IP Lookup to obtain location details for a list of IP Addresses in order to map them in Power BI.   For detailed instructions, please see th...
IPAddressMapping_Jan2021.pbix65 KB
Business
Entertainment
how to
Social Media
mwilner's avatar
mwilner
New Member
6 years ago

I am new to PowerBI and I have been trying to follow the instructions but found it didn't work for me as described.

I think in the GetAllFromIP the "Source = (FullURL) =>" should be Source = (FullIPURLCity) =>, right because that's how the column was named?

Then when trying to apply the query editor only the column FullIPURLCity is getting created but I don't get the table that should be coming from the GetAllFromIP function, I am missing a step I guess.

Trying to run just the function I get an error that the resulting format is HTML not JSON as expected, again, I think I am missing a step.

 

Any help, or ideas to fix this would be appreciated.

\Manfred

 

  • © 2026 Microsoft
  • Manage cookies
  • Privacy & cookies
  • Terms of use
  • Trademarks
Your Privacy Choices Consumer Health Privacy