Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

Power BI Service + Redshift native connector = SSL problem

Submitted by Anonymous on ‎03-24-2018 04:14 AM

I'm connecting to a Redshift source (hosted by panoply.io). In Power BI Desktop it works only if I disable Encryption in Data Source. But after uploading to Power BI Service refreshing won't work:

 

"Failed to update data source credentials: ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] SSL error: certificate verify failed"

Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
v-jiascu-msft
Microsoft Employee
Microsoft Employee
‎03-26-2018 11:44 PM

Hi @Anonymous,

 

Maybe the PostGreSQL connector is more compatible. Please give it a try. If you insist on the Amazon Redshift connector, I would suggest you create a support ticket here. Because the data source isn't a native Redshift DB. 

Power_BI_Service

 

 

Best Regards,

Dale

Anonymous
Not applicable
‎03-29-2018 11:23 PM

Hi! I talked to Panoply and understand they have a dialogue with MS about this. Postgres connector is currently not working well with Redshift since the connector uses the SQL-command UNLISTEN which is not supported by Redshift. So until this is fixed I'll use Redshift ODBC through the Gateway.

Idea Statuses