Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.