Forum Discussion
Why does my Custom Connector not refresh?
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
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-limitations 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?
2 Replies
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-limitations 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?
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