topic Custom BI Connector - Create UI parameters dynamically in Developer

Custom BI Connector - Create UI parameters dynamically

RaBu78 — Tue, 28 Oct 2025 13:52:42 GMT

Dear all,

I'm developing a custom BI connector and I can show input parameters (e.g. date) in this here:

I do this via this code in M:

let dataFunction = (param1 as any, optional param2 as any) as table => GetData(actions, params, {param1, param2}, serverUrl), typeParam = type function ( param1 as (type date meta [ Documentation.FieldCaption = "Start Date", Documentation.FieldDescription = "Start of time range", Documentation.SampleValues = {#date(2024, 1, 1)} ]), optional param2 as (type date meta [ Documentation.FieldCaption = "End Date", Documentation.FieldDescription = "End of time range", Documentation.SampleValues = {#date(2024, 12, 31)} ]) ) as table in Value.ReplaceType(dataFunction, typeParam)

That works without any problem :).

So now the problem is: I get a parameter list via json with each entry like [ Name = "StartDate", Type = "type date", IsOptional = "false"... ] and I want to create the parameters for the UI dynamically by the data of the parameter list. That means the parameter count is not the same, the parameter types are not always the same and the optional parameter can be different. How can I create the UI parameter inputs by the definition of the json.

Does anybody have a solution for this?

Best regards

Rainer

Re: Custom BI Connector - Create UI parameters dynamically

lbendlin — Tue, 28 Oct 2025 19:28:18 GMT

I want to create the parameters for the UI dynamically

I don't think you can do that. Parameters need to be static.

Re: Custom BI Connector - Create UI parameters dynamically

v-venuppu — Thu, 30 Oct 2025 06:36:15 GMT

Hi @RaBu78 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @lbendlin for the prompt response.

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

Re: Custom BI Connector - Create UI parameters dynamically

v-venuppu — Mon, 03 Nov 2025 10:27:07 GMT

Hi @RaBu78 ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.