Sathiya Sarathi
Reputation: 439
Power BI Service - Unable to refresh a postgresql source which doesn't support encrypted connections
I'm trying to refresh the data on a PostgreSQL server running on AWS with no SSL certificate on it.
I'm able to refresh the datasets in the Power BI Desktop. However, I'm neither able to refresh nor able to perform a scheduled refresh in the Power BI service.
How do we connect to a Postgres server which has no SSL certificate on it and perform a refresh on power BI service?
I'm getting the following error: 
Upvotes: 0
Views: 7753
Answers (1)
Sathiya Sarathi
Reputation: 439
Figured it out. The option was actually under the advanced settings of the dataset that was added to the gateway.
Upvotes: 3
Related Questions
- Power Query error in connecting to data source using an encrypted connection
- unable to refresh power Bi data in AWS ODBC: ERROR [08S01] [Simba][DriverIAMSupport] (8600)
- Cannot connect on-premise gateway with postgres on PowerBI
- Power Bi PostgreSQL data import error - The remote certificate is invalid according to the validation procedure.'"
- Data Source Credentials and Scheduled Refresh greyed out in Power BI Service
- Connecting PowerBI Cloud to PostgreSQL
- Power BI live connection to PostgreSQL
- How to connect Power BI to PostgreSQL
- Connect Power BI Service to PostgreSQL Database on Azure
- Npgsql 3.0.3 error with Power BI Desktop