Data Source change

[dmagos]

Hello, 
I recently moved from a local sever to an AWS Lightsail one.

I am trying to change the source of my reports' data (tables) to my new AWS database and it keeps on showing 

DataSource.Error: An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'
Details:
DataSourceKind=PostgreSQL
DataSourcePath= (the path of my AWS Endpoint)

Any suggestions ?

(both of the databases are postgres the local and the AWS)

[Anonymous · Accepted solution]

Hi, @dmagos 

Thanks for rajendraongole1's reply. The documentation states that you need to Configure the public availability of your PostgreSQL database in order to increase accessibility for external users, for details you can check the following documentation.

https://docs.aws.amazon.com/lightsail/latest/userguide/amazon-lightsail-connecting-to-your-postgres-...

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[rajendraongole1]

Hi @dmagos - as per above information, power bi is rejecting the SSL certificate provided by your AWS Lightsail PostgreSQL instance because it cannot validate it. This usually happens when the database uses a self-signed certificate or an invalid/expired certificate.

The AWS security group allows inbound traffic from your Power BI client IP address on the PostgreSQL port (default is 5432).

The hostname in your connection string matches the Common Name (CN) or Subject Alternative Name (SAN) of the SSL certificate.

ref:

PowerBI Web does not trust AWS RDS certificate aut... - Microsoft Fabric Community

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.SSL.html

Hope this helps.

[dmagos]

it kind of reolved but now there is a different problem...

when it asks me for the credentials i input them and it does not accept them. it gives me this error

fyi i am 1000% sure that the User name and password are correct

any ideas ?