Can't assign a gateway to my datasource

[RobHess05]

I can't seem to select a gateway for my dataset.

I only have one gateway configured, and the radio button in not available.

I can click on Manually add to gateway

this allows me to add a new data source, and successfully test.

but the I still can't connect to the gateway.

What am I missing?  Thanks for reading.

[lbendlin]

I'm not aware of any tenant level settings that could influence this but I'll have another look.  Would you consider trying  a separate, simpler custom connector for testing?

Also note:

Considerations and limitations

• Make sure the folder you create is accessible to the background gateway service. Typically, folders under your user’s Windows folder or system folders won’t be accessible. The on-premises data gateway app shows a message if the folder isn't accessible. This instruction doesn't apply for the on-premises data gateway (personal mode).
• For custom connectors to work with the on-premises data gateway, they need to implement a “TestConnection” section in the custom connector’s code. This section isn't required when you use custom connectors with Power BI Desktop. For this reason, you can have a connector that works with Power BI Desktop, but not with the gateway. For more information on how to implement a TestConnection section, see this documentation.
• If your custom connector is on a network drive, include the fully qualified path on the on-premises data gateway app.
• You can only use one custom connector data source when working in DirectQuery mode; multiple custom connector data sources will not work when using DirectQuery.

[RobHess05]

Thank you for the documentation.  I did follow these instructions, including creating a Test Connection in my connector code.  I was able to successfully connect the service to my personal gateway, but it isn't connecting with the standard gateway.  This tells me that my connector is fine, but there's something different about the standard gateway.

[RobHess05]

Thank you for the feedback.  I uninstalled \ reinstalled the connector, and used the default service account and gateway.

I recreated the gateway and datasource for good luck

but the dataset is still throwing the same error

[lbendlin]

One more question - did you allow custom connector refresh through the gateway?

Use custom data connectors with the on-premises data gateway - Power BI | Microsoft Docs

[RobHess05]

I did.  That's what exposed my custom Data Source Type

[lbendlin]

that looks like a custom connector created by your company. You'd want to discuss this with the creators of the connector and with the gateway cluster admins.

[RobHess05]

Yes, it's a custom connector.  I'm the developer and the gateway admin.  I have no problems authenticating and syncing data from the Power BI desktop with my custom connector.  I also had this successfully refreshing in the personal gateway, but recently moved to the standard gateway.

[lbendlin]

Did you install the custom connector on all gateway cluster members in the designated folder?  Did you confirm that the custom connector is successfully loaded in each cluster member?  Something like this:

[RobHess05]

Yes, the custom connector is attached to the gateway.   There's only one gateway in play.

[lbendlin]

I don't think that's a good location for the connector code.  Are you running the gateway service on something other than the default account?