Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Solved! Go to 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.
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.
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
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.
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)
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.
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
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
Hi @v-cboorla-msft ,
Thank you for your constant support, my issue has been resolved. 🙂
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
Check out the November 2024 Fabric update to learn about new features.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
15 | |
6 | |
6 | |
4 | |
4 |