Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I would like to create a GeoIP lookup function. In Desktop I would create the following Power Query and add custom column to the data source.
let get_geo = (IPAddress as text) => let Source = Json.Document(Web.Contents("http://ip-api.com/json/"&IPAddress&"")), #"Converted to Table" = Record.ToTable(Source), #"Filtered Rows" = Table.SelectRows(#"Converted to Table", each ([Name] = "city" or [Name] = "country" or [Name] = "countryCode" or [Name] = "query")), #"Transposed Table" = Table.Transpose(#"Filtered Rows"), #"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table") in #"Promoted Headers" in get_geo
However I can't see any obvious way in service edition to add the Power query. I am sure I am missing something obvious.
Thank you
Russell
Solved! Go to Solution.
@russdev You can't create power query function straight through power bi service. you have to create them in power bi desktop, use there and they get published as part of your publish from power bi desktop. If you're using that funciton in your other queries they will be applied when you refresh via power bi service.
@russdev You can't create power query function straight through power bi service. you have to create them in power bi desktop, use there and they get published as part of your publish from power bi desktop. If you're using that funciton in your other queries they will be applied when you refresh via power bi service.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.