Forum Discussion
Power Query: Olad connection query creates some custom functions. Where are they to view/edit?
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
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
2 Replies
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
