null value in parameter dropdowns of custom connector with Standard Gateway

[Jigar1276]

Hello,

I am using custom connector which have few dropdowns for parameters. The parameter dropdown is shown as null whenever this connector is used with standard gateway. Please refer the bellow screenshot.

However, the same connector is working fine with personal gateway and parameter dropdowns shows the actuall values.

Please advice. Thanks in advance.

[Jigar1276]

I have raised the ticket on 28-Jan-2021, and ticket number is 121012823001007. This ticket is still open.

Is there any direct link to ticket so I can open the ticket in Microsoft support website?

[v-deddai1-msft]

Hi @Jigar1276 ,

Would you please check if you have enabled and used this capability? In Connectors tab in the on-premises data gateway app,  select a folder that can be accessed by the user running the gateway service.The gateway automatically loads the custom connector files located in that folder. They appear in the list of data connectors.

If you're using the on-premises data gateway (personal mode), you can upload your Power BI report to the Power BI service and use the gateway to refresh it.

For the on-premises data gateway,on the gateway settings page in the Power BI service, you should see an option when you select the gateway cluster to allow using custom connectors with this cluster. 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Jigar1276]

Hi Dedmon,

Thanks for the response. Yes I can see the custom connectors in connectors tab in gateway. Also the check box is ticked to allow user's custom connectors. 

I can see the connector is loaded on app.powerbi.com as per my screenshot in original post. But parameter dropdowns are showing the values as null.

[v-deddai1-msft]

Hi @Jigar1276 ,

To support scheduled refresh through the on-premises data gateway, your connector must implement a TestConnection handler. For mor details, please refer to https://docs.microsoft.com/en-us/power-query/handlinggatewaysupport

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Jigar1276]

Hi @v-deddai1-msft 

I have already TestConnection in place in my custom connector.

[v-deddai1-msft]

Hi @Jigar1276 ,

Your code looks well, but I really can't reproduce your issue. I suggest open a support ticket, 

 Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

Best Regards,

Dedmon Dai

[Jigar1276]

Hi @v-deddai1-msft ,

Thanks for the guidance. I have raised a support case.