Custom Connector raising error with Data Gateway in Power BI Service

[jaime_blackwell]

Hi Community,

I've just built a custom connector to enable me to connect to Xero's API. It is working in Power BI Desktop, but fails to refresh in Power BI Service.  here: https://gist.github.com/jaimeblackwell/1e510ba24c4d71a0c5a6902e29e2da5b

I have installed and set up both Data Gateway Personal and Shared. The credentials I'm using are definitely correct and work fine in Desktop. 

I have the TestConnection line in my code which I believe should make the connector compatible with Gateway.

Can anyone offer any suggestions or advice?

Thank you!

[V-lianl-msft]

Hi @jaime_blackwell ,

1. Add a TestConnection handler to your connector
2. Install the On-Premises Data Gateway in Personal mode
3. Enable Custom Connector support in the Gateway
4. Publish a workbook that uses your connector to PowerBI.com
5. Configure scheduled refresh to test your connector

Please refer to :

https://docs.microsoft.com/en-us/power-query/samples/trippin/9-testconnection/readme 

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

[jaime_blackwell]

Hi Liang,

I'm not sure if you read my post. I've already completed those steps and I'm still experience the error. Do you have any advice for resolving this? Thanks!