Forum Discussion
Power Query: Olad connection query creates some custom functions. Where are they to view/edit?
Many thanks for your reply amitchandak.
Unfortunatley no.
For the fx function 'fx City' , in the advance editor I just get:
let
Source = OData.Feed("odatalink", null, [Implementation="2.0"]),
#"x" = Source{[Name="City",Signature="function (Year as number) as table"]}[Data]
in
#"x"When I start from fresh and import the data, I can tick boxes that will import the functions. I find it strange you can import functions from OData.
I can't see what the functions do!
Many thanks
Anonymous , Is that not visible in power query under tables on left?
https://www.sqlservercentral.com/articles/create-custom-functions-in-power-query
Many thanks for your reply amitchandak.
Unfortunatley no.
For the fx function 'fx City' , in the advance editor I just get:
let
Source = OData.Feed("odatalink", null, [Implementation="2.0"]),
#"x" = Source{[Name="City",Signature="function (Year as number) as table"]}[Data]
in
#"x"
When I start from fresh and import the data, I can tick boxes that will import the functions. I find it strange you can import functions from OData.
I can't see what the functions do!
Many thanks