Anyone know how to create a custom function with optional values in the query itself?

[arpost]

Greetings, community. Have a problem and am hoping a Power Query/M guru out there can help me.

I'm trying to create a custom function from a query and cannot figure out how to make it so any parameters used in the query are optional WITHOUT breaking the connection between the function and the query.

As an example, I have a super basic query with a single step:

This query uses a parameter called Param that is a decimal type.

When I tried to make the parameter optional in the custom function, I get a warning that this will break the link to the query:

Does anyone know of a way to make a parameter optional in the query itself? Or do we always have to break the function-query connection to alter parameters like that?

[gafoorgk]

I was going to ask the same question, then found this post where no one answered. Seems this is not possible in Power Query even when a parameter is created with 'Required' option is turned off. Only option is to break the connection. That would make updating function a bit tedious process.