Unable to connect Power BI with Amazon Redshift Serverless (Serverless Version)

0

There are many tutorials available for clustered Redshift, but there are no tutorials for the serverless type to connect it to Power BI. My issue is that I don't know how to configure Redshift for connecting to Power BI, and I'm not sure which username and password to use in the username and password section (IAM User name or Account ID or ..).

Error that I get:

Details: "ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "default-endpoint-zj.3.eu-central-1.redshift-serverless.amazonaws.com" (10...) and accepting TCP/IP connections on port 5...? "

1 Answer
1
Accepted Answer

Hello.

If you are trying to connect from outside your VPC, you will need to enable public access as described in the documentation below.
https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-connecting.html#serverless-publicly-accessible

I believe the username and password use the database user within Redshift, not the IAM user.
https://learn.microsoft.com/en-us/power-query/connectors/amazon-redshift
https://aws.amazon.com/jp/blogs/big-data/integrate-power-bi-with-amazon-redshift-for-insights-and-analytics/

profile picture
EXPERT
answered 7 months ago
profile picture
EXPERT
reviewed 6 days ago
  • It is already "public access" but still show me above error, I follow these process: 1- "get data" in power BI 2- Choose Amazon Redshift in the list 3- write my "endpoint" in the "Server" part and Database name in "Database" 4- write username and pass (test Account ID and IAM ID both) 5- then error show up

  • Based on the content of the error, a timeout error has occurred, so perhaps there is a problem with the security group? Is the global IP address of the connection source allowed in the security group's inbound rules? https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-connecting.html#serverless-publicly-accessible
    Also, I think the user name will be the name of the administrator user set when creating RedShift, not the IAM user.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions