使用AWS re:Post即您表示您同意 AWS re:Post 使用条款
AWS re:Postre:Post

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

主题
无服务器安全、身份和合规性管理与治理分析网络和内容交付
标签
无服务器安全、身份和合规性AWS 管理控制台Amazon Redshift域名系统 (DNS)
语言
English
Majid
已提问 7 个月前692 查看次数
1 回答
0
已接受的回答

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
专家
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.

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈，并能促进提问者的职业发展。

回答问题的准则

相关内容