Custom Connector - Test Connection - Navigation Pane

acanepa — Tue, 18 Aug 2020 12:34:04 GMT

Hello,

I'm building a Proof of concept of a custom connector, and I'm having some issues at the moment of displaying the data in the navigation pane. I can retrieve data just fine without navigation pane, the key I'm using, a refresh token, works great if I retrieve a table directly. But because I'm using a TestConnection clause, the navigation pane seems use that method of authentication instead of the "normal" one.

Currently, I'm using this code for "Data Source Kind description".

PQExtension1 = [ // TestConnection is required to enable the connector through the Gateway TestConnection = (dataSourcePath) => { "PQExtension1.Contents" }, Authentication = [ Key = [Label= "Refresh Token"] ], Label = "Test Connection" ];

I'm using the function below to use the refresh token.

Extension.CurrentCredential()[Key]

For demonstration purposes, I've established the name of the table in the navigation pane, as the refresh token.

If I do the call from Visual Studio, I get the refresh token in the name, as the image below

But, similarly, if I do the same action on PoweBi the name changes to TestConnection = (datasourcepath) =>

Do you know how to solve this? Do I need to change the definition inside the TestConnection?

I'm using TestConnection for being able to use a Data Gateway. I got the examples from TriPin Github.

https://github.com/microsoft/DataConnectors/blob/master/samples/TripPin/9-TestConnection/TripPin.pq

https://docs.microsoft.com/en-us/power-query/handlinggatewaysupport

Regards,

topic Custom Connector - Test Connection - Navigation Pane in Developer

Custom Connector - Test Connection - Navigation Pane