04-20-2017 11:10 AM
I can connect to redshift with desktop but not via the service. I think I added the correct IP address. Our cluster is configured with force_ssl=true, if that matters. Getting this error:
The credentials you provided for the data source are invalid. Please check the credentials for all the data sources.
|Time:||Thu Apr 20 2017 21:03:04 GMT+0300 (Jerusalem Daylight Time)|
As the error message said, you credential is not valid. You need to edit the credential in Datast Settings. For more details, please see: Announcing support for Amazon Redshift connectivity in the Power BI service
I don't think that's the problem. I don't see any new entries in STL_CONNECTION_LOG after creating credentials and connection attemp. Like I said, I'm pretty sure the ip address is correct.
Whereas in desktop, the connection is successful and appear in STL_CONNECTION_LOG. Though in desktop it gives a warning says, "source doesn't support encryption" even though force_ssl=true. (Not sure if that's related.)