Forum Discussion
We couldn't authenticate with the credentials provided. Please try again - Using right credential
Super User
Please check if the credentails that you have are accurate, try to connect to your postgres source from any other tool like dbeaver and see if that works. If not then your credentails are not accurate.
If you are able to connect from other tools but not from Power BI desktop then,
1. Click on transform data drop down
2. Click on Datasource settings and under global datasources, try to find your postgres source
3. Right click on it and click on delete permissions
4. Try to connect to your source again and enter the credentails correctly.
Also, I am assuming you have all the necessary prerequisites to establish the connection from Power BI desktop to postgres. Pleaase check out this documentation
https://learn.microsoft.com/en-us/power-query/connectors/postgresql
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|
I have done thus procedure several times but after global permission i am not able to get my or any postgres source.
So it would be real help if you can guide me on how to get your postgres source there or any another solution.
- tharunkumarRTK
Sources which are used in the current file will appear in the "Data sources in current file" tab and similarly all the sources that you had previously connected since the installation will appear under global permissions tab.
There is no other way to manaully add the connection to global permissions tab other than establishing the connection to the source.
I am not sure whether you tried validating the credentials from any client tool like dbeaver. If not then please do so.
1. Also make sure you are using latest version of power bi desktop which has the NpgSQL bundled with it, if not you need to manully install it. (check the link that I have shared previously
2. Depending on where the postgres source is hosted, you would need to install necessary certificates in your machine.
3. If your source does not support encrypted connection then you need to disable the encryption.
Please validate all the necessary prerequisites
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
