Forum Discussion
Setting Up TLS Between Power BI Report Server and PostgreSQL Using Npgsql
You can use the above mentioned steps to set up a secure TLS connection between Power BI Report Server and PostgreSQL using Npgsql.
In addition to AmiraBedh,
If you want to enforce client-side SSL verification:
You can use-
***********************************
ssl_verify_client = require
***********************************
If you don’t have valid SSL certificates for your PostgreSQL server, you can generate self-signed certificates.
To generate a self-signed certificate and private key (for testing purposes):
***********************************
# Create a private key
openssl genpkey -algorithm RSA -out server.key
# Create a self-signed certificate
openssl req -new -x509 -key server.key -out server.crt -days 365
***********************************
Ensure the SSL certificates are valid, properly formatted, and correctly located in the postgresql.conf file.
By following these steps, you should be able to set up a secure TLS connection between Power BI Report Server and PostgreSQL using Npgsql.
Hope this helps!
The ones that are in bold are commands and it world be better if they are screenshots.
I couldnt edit it in word thats why used notepad.
But you can use these in place of them-
If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.