Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
    Anonymous
    Not applicable
    4 years ago

    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