Custom connector Power Query Windows Authentication Options

[FrancescaBatt]

Dear Forum members,

I'm developing a custom Power BI connector and I would like to know if it is possible to modify / customize the authentication options.

I would like to obtain two authentication:

- OAuth2 type, that takes in input two parameters clientid and clientsecret

- Basic with username e password

The problem is that I can not use the basic authentication twice and I wanted to take advantage of the Windows connection to have two parameters as input: but is it possible delete the options "Use my current credentials", "My alternate credentials" and show only Username and Password?

Thank you!

[rajulshah]

@FrancescaBatt How did you get the label name to change to ClientId or ClientSecret in OAuth2?

[FrancescaBatt]

Hi, you can refer to the documentation: Handling authentication for Power Query connectors - Power Query | Microsoft Learn. I only managed the possible labels indicated in the Authentication Kinds table.

For example for the Basic: UsernameLabel, PasswordLabel and Label.

I hope this works for you!

Regards

Francesca

[FrancescaBatt]

Hi @v-jingzhang ,

Many thanks for your answer. 

Unfortunately we can't use the OAuth2 "standard" because our is not the authentication through authorization url and authorization_code as response.

We only need to ask for two parameters Client Id and Client Secret that are used to retrieve the token to be concatenated to web calls without Start Login and End Login process.

Is there a way to "skip" the method Start Login and End Login and ask directly for the client id and client secret for the OAuth2 authentication?

I think the only way is to customize the labels for the Basic Authentication.

Thank you very much

[v-jingzhang]

Hi @FrancescaBatt 

It seems not supported to delete the options of the Windows connection. You can only choose whether to pass values for the following labels of this connection. Handling authentication for Power Query connectors - Power Query

If you want to build a custom connector that supports OAuth2, this blog might be helpful:

Building a custom connector for Power BI that supports OAuth2 to visualize my wellness data - Jussi ...

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.