null value in parameter dropdowns of custom connector with Standard Gateway

Question

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.&nbsp;However, the same connector is working fine with personal gateway and parameter dropdowns shows the actuall values.Please advice. Thanks in advance.

v-deddai1-msft · Answer

Hi&nbsp;Jigar1276&nbsp;,&nbsp;Would you please check if you have enabled and used this capability? In&nbsp;Connectors&nbsp;tab in the on-premises data gateway app,&nbsp;&nbsp;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.&nbsp;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.&nbsp;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.&nbsp;If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.&nbsp;Best Regards,Dedmon Dai

jigar1276 · Answer

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.&nbsp;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 · Answer

Hi&nbsp;Jigar1276&nbsp;,&nbsp;To support scheduled refresh through the on-premises data gateway, your connector&nbsp;must&nbsp;implement a TestConnection handler. For mor details, please refer to&nbsp;https://docs.microsoft.com/en-us/power-query/handlinggatewaysupport&nbsp;If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.&nbsp;Best Regards,Dedmon Dai&nbsp;

jigar1276 · Answer

Hi&nbsp;v-deddai1-msft&nbsp;I have already TestConnection in place in my custom connector.&nbsp;

v-deddai1-msft · Answer

Hi&nbsp;Jigar1276&nbsp;,&nbsp;Your code looks well, but I really can't reproduce your issue. I suggest open a support ticket,&nbsp;&nbsp;Go to&nbsp;https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".&nbsp;Best Regards,Dedmon Dai

Forum Discussion

null value in parameter dropdowns of custom connector with Standard Gateway

7 Replies

Related content

Dropdown for Parameter not showing

Custom connector parameters

Parameter in summarize

Custom BI Connector - Create UI parameters dynamically

Dropdown Slicer