Forum Discussion
SSL Certificate Error: Power BI Desktop to AWS RDS Connection Fails
Hi Team,
I wanted to share an update on the AWS RDS connection issue in Power BI, which I had posted on the Power BI community earlier. I was able to resolve the problem by adding an environment variable `PBI_SQL_TRUSTED_SERVERS` to my system. This allowed Power BI to trust the RDS instance, and the connection was established successfully.
If anyone is facing similar issues, here’s a general approach:
1. Add the `PBI_SQL_TRUSTED_SERVERS` environment variable on the machine where Power BI is running.
2. Set its value to include your RDS server (e.g., `your-rds-instance-url:port`).
3. Restart Power BI and try connecting again.This resolved the SSL certificate trust issue that was causing the error.
Feel free to reach out if you need further details!
Best regards,
Manoj Prabhakar
Hi Team,
I wanted to share an update on the AWS RDS connection issue in Power BI, which I had posted on the Power BI community earlier. I was able to resolve the problem by adding an environment variable `PBI_SQL_TRUSTED_SERVERS` to my system. This allowed Power BI to trust the RDS instance, and the connection was established successfully.
If anyone is facing similar issues, here’s a general approach:
1. Add the `PBI_SQL_TRUSTED_SERVERS` environment variable on the machine where Power BI is running.
2. Set its value to include your RDS server (e.g., `your-rds-instance-url:port`).
3. Restart Power BI and try connecting again.
This resolved the SSL certificate trust issue that was causing the error.
Feel free to reach out if you need further details!
Best regards,
Manoj Prabhakar