Forum Discussion

jaime_blackwell's avatar
jaime_blackwell
Helper I
5 years ago

Custom Connector raising error with Data Gateway in Power BI Service

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!

 

 

 

Need Help

2 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    5 years ago

    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's avatar
      jaime_blackwell
      Helper I
      5 years ago

      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!