Power Query: optional parameter of type table defaults to #"null"

[MarcelBeug]

If a custom function is created with an optional parameter of type table: when the function is invoked via the query list or via the Query Editor - Add Column - Invoke Custom Function, without a value for the optional parameter of type table, the function is invoked with #"null" for the table parameter, instead of null.

This causes an expression error stating that the name 'null' wasn't recognized.

[v-haibl-msft]

@MarcelBeug

Could you please provide a PBIX file for this issue? You can upload it to online file service like OneDrive and share it.

Best Regards,

Herbert

[MarcelBeug]

Here is the PBIX file and a short video with explanation

[v-haibl-msft]

@MarcelBeug

Thanks for the detailed info, I've reported it internally to Power BI Team: CRI 30828795

I'll post here once I get any update about it.

Best Regards,

Herbert

[v-haibl-msft]

@MarcelBeug

A fix will be available in the March release of PBI Desktop.

Best Regards,

Herbert