Power Query In Service Edition

[russdev]

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

[ankitpatira · Accepted 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.