Creating a custom PostgreSQL connector with the power query SDK

Hi AntonyKlipper ,

Here are a few things you can try to check:

Authentication Definition: Ensure that the Authentication section is correctly defined and that the credentials are being passed properly.
Connection String: Verify that the connection string is correctly formatted and includes all necessary parameters.
Error Handling: Add error handling to capture and display any issues that occur during the connection process.

Also, you can check the steps to Implement Microsoft Entra ID Authentication:

1. Register Your Application:

   • Go to the Microsoft Entra admin center and register your application.
   • Note down the Directory (tenant) ID and Application (client) ID.

2. Configure OAuth:

   • Update your connector to use OAuth for authentication.
   • Define the StartLogin, FinishLogin, and Refresh functions for the OAuth flow.

3. Update Connector Definition:

   • Modify the Authentication section to include the Aad authentication kind.

Example:

MyConnector = [
    Authentication = [
        Aad = [
            AuthorizationUri = "https://login.microsoftonline.com/common/oauth2/authorize",
            Resource = "{YourApplicationIdUri}"
            Scope = ".default"
        ]
    ]
];

Configuring Microsoft Entra for a custom connector - Power Query | Microsoft Learn

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.