Forum Discussion

tjamal's avatar
tjamal
Regular Visitor
7 years ago

Unable to connect to Amazon Redshift Data Source on PBI Service

Hi,

 

I have created a report by connecting directly to an Amazon Redshift data source (not through an ODBC driver) and am unable to refresh this report on PBI Service, seemingly due to a credentials issue. 

 

When entering in my credentials for my Redshift data source from the dataset settings menu, I recieve the following error message:

Failed to update data source credentials: ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] could not connect to server: Permission denied (0x0000271D/10013) Is the server running on host "ServerName" (#.#.#.#) and accepting TCP/IP connections on port 5439? Hide details

Activity ID:46b9a97b-eaf7-454a-8035-1c5148ba9481
Request ID:93b5b63b-b78e-dce1-5769-c72257a9ca5e
Status code:400
Time:Mon Apr 29 2019 18:25:20 GMT-0700 (Pacific Daylight Time)
Version:13.0.9264.134
Cluster URI:https://wabi-west-us-redirect.analysis.windows.net

 

I have verified that I can connect to the Redshift source through SQL clients and Power BI Desktop using the same credentials. Ultimately, I'm unable to refresh the report on PBI Service as I cannot seem authenticate credentials, but oddly enough, refreshing works fine on the corresponding PBI Desktop file.