Custom Connectors with optional parameters only - UI not displaying in Power BI Desktop

[Anonymous]

If you create a custom connector with optional parameter(s) only, the UI does not display. Instead Power BI desktop automatically provides null value(s) and the data source function is immediately executed returning data. Optional parameters should still display the UI and allow the user to enter optional value(s) in. If there is at least one mandatory parameter, the UI displays and includes the optional parameters too. I would like to have a data source with only a single optional parameter, so that the data source path is the same value for all invokations (optional parameters are not included in the data source path).

[v-yuta-msft]

@Anonymous ,

So your requirement is to include a single optional parameter UI in your custom connector, right? I would suggest you to refer to this blog about how to create an improve the custom connector.

https://blog.crossjoin.co.uk/category/custom-data-connectors/

Regards,

Jimmy Tao

[xsgao]

Check this out, https://learn.microsoft.com/en-us/power-query/handlingauthentication#data-source-paths. Did you try DataSource.Path = true for your optimal parameter?