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

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...? "

주제

서버리스 보안, 신원 및 규정 준수 관리 및 거버넌스 분석 네트워킹 및 콘텐츠 전송

태그

서버리스 보안, 신원 및 규정 준수 AWS 관리 콘솔 아마존 Redshift 도메인 이름 시스템(DNS)

언어

English

Majid

질문됨 7달 전690회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

수락된 답변

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/

전문가

Riku_Kobayashi

답변함 7달 전

Majid
7달 전
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
Riku_Kobayashi 전문가
7달 전
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.

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

관련 콘텐츠