Why does my Custom Connector not refresh?

[Anonymous]

Hi Guys,

I've successfully created a custom connector and published it on my personal gateway and was able to refresh it. Due to company policy, I can't keep that connector on my gateway and have had to migrate it to another cluster on which I am not an Admin but a user of that connector. I set up the report, found the connector on the gateway and when I tested the refresh, it gave me this error:

{"error":
  {"code":"PowerBINotAuthorizedException","pbi.error": 
    {"code":"PowerBINotAuthorizedException",
     "parameters":{},
     "details":[],
     "exceptionCulprit":1
    }
  }
}

Please can you support?

Kind Regards,

Andrei

[d_gosbell · Accepted solution]

I have not done a lot of work with custom connectors but this page https://docs.microsoft.com/en-us/power-bi/service-gateway-custom-connectors#considerations-and-limit... has the following note in the section on Considerations and Limitations :

• 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.

Have you created a TestConnection method in your connector?

[Anonymous]

Hi,

Yes I can confirm the TestConnection has been added. It worked on My personal Gateway. 

I think I have found the reason in the document you provided. In the last bullet point it says:

• OAuth for custom connectors via gateways is currently supported only for gateway admins but not other data source users.

That's not a good news after all the work I've put in. Thanks for the support