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.
