Power Query: Olad connection query creates some custom functions. Where are they to view/edit?

[Anonymous]

I have an OData query:

= OData.Feed("https://myodatafeed", null, [Implementation="2.0"])

that creates a table with 3 columns, one called 'Data' that either shows Table or Column links that you can click on.  Clicking on Table is ok as it creates a table.

If you click on 'Function' it invokes a function which asks for a parameter and then creates a table filtered on what you entered.

looking at the Invoked Function in the Advanced Editor, you get:

let
Source = CityOnPeriodDates(#datetimezone(2021, 11, 19, 0, 0, 0, 0, 0))
in
Source

The issue is that I cannot find the function anywhere to edit/view.

Anybody know where I can find it?

The OData query seems to create the function out of nowhere.

Many thanks for looking

[amitchandak]

@Anonymous , Is that not visible in power query under tables on left?

https://www.sqlservercentral.com/articles/create-custom-functions-in-power-query

[Anonymous · Accepted solution]

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