By using AWS re:Post, you agree to the AWS re:Post Terms of Use
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...? "

Topics
ServerlessSecurity, Identity, & ComplianceManagement & GovernanceAnalyticsNetworking & Content Delivery
Tags
ServerlessSecurity, Identity, & ComplianceAWS Management ConsoleAmazon RedshiftDomain Name System (DNS)
Language
English
Majid
asked 6 months ago641 views
1 Answer
0
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
Riku_Kobayashi
answered 6 months ago
  • Majid
    6 months 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

  • Riku_Kobayashi EXPERT
    6 months ago

    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

Relevant content