Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
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,
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |