power query sdk debugging

[smpa01]

@Anonymous @miguel 

@AlexisOlson @ImkeF 

I am trying to develop a test connector to a ms-sql server using pqsdk. this is giving me a credential error as following.

This is the production server which I can connect using power query's built-in sql connector and it requires me to put my credential through OAuth Log in window.

I am not sure how can I achieve this?

[Anonymous]

Hi @smpa01 ,

Make sure that the pqsdk settings contain the correct OAuth configuration. This may involve setting up the OAuth Client ID, Customer Secret, and Redirect URI correctly.

Verify that the code retrieves and uses the OAuth token correctly. You may need to implement a process to handle the OAuth sign-in and token retrieval process.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[smpa01]

Is there a working example of OAuth you can share for me to refer the use case please. I don't have experience here.

[Anonymous]

Hi @smpa01 ,

Sure! Here are some useful resources that provide detailed examples and guides on implementing OAuth:

How to implement OAuth 2.0 in Node.js - LogRocket Blog

The complete guide to protecting your APIs with OAuth2 (part 1) - Stack Overflow

Guide to implementing OAuth 2.0 (with examples)

These resources should help you understand and implement OAuth in your project. If you need further assistance, feel free to ask!

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.