Not able to connect to Power BI

The error you're encountering suggests that there might be connectivity issues between Power BI and your Amazon Redshift cluster. Here are some steps you can take to troubleshoot and resolve this issue:

1. Check if your Redshift cluster is publicly accessible. If it's in a private subnet, you'll need to use an on-premises data gateway to connect from Power BI service to Amazon Redshift.

2. Verify that the security group associated with your Redshift cluster allows inbound traffic from the IP address where Power BI is running. You may need to add your current IP address to the inbound rules of the security group.

3. Ensure that you're using the correct endpoint, port (usually 5439), database name, username, and password in your Power BI connection settings.

4. If you're connecting from outside your VPC and haven't enabled public access, you'll need to do so. This can be done through the AWS Redshift management console.

5. Check if SSL is required for your Redshift connections and ensure your connection string in Power BI includes the necessary SSL parameters.

6. If you're using Power BI Desktop, make sure you're using the latest version which supports the most recent Redshift drivers.

7. Consider using AWS PrivateLink or setting up a VPN connection if you need a more secure way to access your Redshift cluster.

If these steps don't resolve the issue, you may want to contact AWS Support for further assistance with your Redshift configuration or Microsoft Power BI Support for help with the connection settings on the Power BI side.

Remember, it's important to follow security best practices when configuring access to your Redshift cluster, such as using the principle of least privilege for user permissions and implementing proper network security measures.

Sources
Unable to connect Power BI with Amazon Redshift Serverless (Serverless Version) | AWS re:Post
Accessing Redshift data in PowerBI | AWS re:Post
Appendix: Microsoft Power BI supported AWS data sources - Using Microsoft Power BI with the AWS Cloud
Connecting Power BI to Provisioned Redshift Cluster - Inbound Rule? | AWS re:Post