The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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,