Unable to connect to postgresql and copy data to fabric warehouse

[Anonymous]

I am trying to import data into a fabric warehouse using data pipeline. After filling the required fields i get the an error stating "Invalid Credentials". Although I am using the correct server name, database name and providing the correct username and password. 

[v-cboorla-msft]

Hi @Anonymous 

Thanks for using Microsoft Fabric Community.

Apologies for the inconvenience that you are facing here.

I tried to repro the scenario connecting a sample PostgreSQL database and was successful, I didn't face any issue in connecting. Find the screenshot for reference.

The error message says that issue is because of credential mismatch:

Double-check that you are indeed using the correct server name, database name, username, and password. Ensure there are no typos or extra spaces in any of these fields.

Clearing your cache and cookies should help improve your browsing experience and resolve any credential-related issues. Give it a try, this might help you.

If the issue still persists please do let us know. Glad to help.

I hope this information helps.

Thanks.

[Anonymous]

Hi @v-cboorla-msft

Although my credentials are correct but I am still facing the same issue. May be I am doing something wrong. Could you explain how you made the connection to PostgreSQL step by step.

Thanks

[v-cboorla-msft]

Hi @Anonymous 

For repro I took sample PostgreSQL database and the DB details are Public Postgres database (rnacentral.org). Please find the step by step procedure for connecting to a sample PostgreSQL DB.

I hope this information helps. Please do let us know in case if you have any further questions.

Thanks.

[Anonymous]

Hi @v-cboorla-msft 

I followed your steps and the solution works for the publicly available database, but my postgres db is hosted on azure and when i enter its credentials, i recieve the following error:

Invalid credentials. (Session ID: 310bb4ab-f068-4b89-ba99-6895108c36aa, Region: europe)

[v-cboorla-msft · Accepted solution]

Hi @Anonymous 

I see in the original post that you are selecting external PostgreSQL Database but whereas in the latest post you are saying that, you are trying to connect to PostgreSQL Database that has hosted on Azure. This might be the reason for the error. 

Could you please select Azure Database for PostgreSQL and try. This might help you.

I hope this information helps. Please do let us know in case if you have any further questions.

Thanks.

[Anonymous]

Hi @v-cboorla-msft , I have used Azure Database for PostgreSQL but I am still facing the credentials invalid error.

Moreover I also get the following error when i test the connection made with the database

28000: no pg_hba.conf entry for host "xx.xx.xx.xx", user "username", database "dbname", SSL off Check network connectivity setting of your Azure Postgre SQL flexible server, if Pirvate Access(VNet integration) is selected, please use SHIR to connect. 28000: no pg_hba.conf entry for host "xx.xx.xx.x", user "username", database "dbname", SSL off

[v-cboorla-msft]

Hi @Anonymous 

Apologies for the onconvenience that you are facing here.

Inorder to understand the exact issue, it requires a deeper investigation from our engineering team about your workspace and the logic behind it to properly understand what might be happening. 

Please go ahead and raise a support ticket to reach our support team: support-ticket 

Please provide the ticket number here as we can keep an eye on it.

Thanks

[Anonymous]

Hi @v-cboorla-msft ,

Thank you for your constant support, my issue has been resolved. 🙂

[v-cboorla-msft]

Hi @Anonymous 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks.

[Anonymous]

Hi @v-cboorla-msft still facing the issue!