March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I've tested a working connector with PowerBI desktop and published this to service but I am facing an issue where the Data Source configuration in the Gateway won't store the OAuth access_token.
I following the guidance regarding TestConnection found here: https://github.com/Microsoft/DataConnectors/blob/master/docs/m-extensions.md#implementing-testconnec...
The issue I am facing is that I click Edit Credentials when configuring a Data Source on the gateway - the OAuth flow start and I click to Allow access but it just takes me back to the popup below (with Add being greyed out).
Here is my VS code:
[DataSource.Kind="AdministrateGraphQL", Publish="AdministrateGraphQL.UI"]
shared AdministrateGraph = (query as text) =>
let
apiToken = "Bearer " & Extension.CurrentCredential()[access_token],
Source = Web.Contents("https://api.getadministrate.com/graphql",
[Headers=[
#"Method"="POST",
#"Content-Type"="application/json",
#"Authorization"=apiToken
],
Content=Text.ToBinary(query)
]),
Output = Json.Document(Source)
in
Output;
[DataSource.Kind="AdministrateGraphQL"]
shared TestAdministrateGraph = (query as text) =>
let
apiToken = "Bearer " & Extension.CurrentCredential()[access_token],
Source = Web.Contents("https://api.getadministrate.com/graphql",
[Headers=[
#"Method"="POST",
#"Content-Type"="application/json",
#"Authorization"=apiToken
],
Content=Text.ToBinary(query)
]),
Output = Json.Document(Source)
in
Output;
// Data Source Kind description
AdministrateGraphQL = [
TestConnection = (dataSourcePath) => { "AdministrateGraph", dataSourcePath },
Authentication = [
OAuth = [
StartLogin=StartLogin,
FinishLogin=FinishLogin,
Refresh=Refresh
]
],
Label = Extension.LoadString("Administrate GraphQL Connector")
];
Is anyone able to highlight why this isn't working?
Hello,
I am working on developping an Oauth2 connector like you but I'm currently not succeeding, would it be possible to see how you've set up your StarLogin and FinishLogin functions ? I'm struggling with these two functions because I don't need any authorize URL to access my toke, I just need to request the token url with some credentials and I get it, no exampe works like this online
Otherwise sorry, I can't help you that much ahah
Anyone have any thoughts?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
9 | |
3 | |
2 | |
2 | |
2 |