OData Get Data: Can import fx custom functions as well as tables. Cannot see what functions do.

[Anonymous]

Hi all

I'm importing data from OData and I'm getting tables to tick to connect to which is normal.

However, I'm also getting the option to load fx function tables.

The problem is I cannot see what these functions do.

If I import one function and invoke it (I enter 2021 as a value), I just see this in the advanced editor:

let 
Source = CitiesActive(2021)
in  Source

It does produce a table with filtered results, which is great.

But there seems to be no way of finding out the workings of this function.

How are these automatically becoming functions from just an import?

Many thanks.

[Anonymous · Accepted solution]

Many thanks Jay.

There's nothing there about automatically importing functions from OData.

I'll keep looking, and post here if I find anything.

[v-jayw-msft]

Hi @Anonymous ,

You may take a look at the document about custom function in Power BI.

https://docs.microsoft.com/en-us/power-query/custom-function 

Best Regards,

Jay