Connecting AWS Redshift to Power BI

[deew95]

Hi All,

I'm trying to connect my AWS Redshift data warehouse to Power BI to get data and build reports on top of that. Got the below error msg where it shows that the connection timeout is expired. I have already created the network rules in the AWS VPC security group and whitelisted my IP address. Still, I'm getting this error. Please support me on this.

Thanks in Advance.

[amitchandak]

@deew95 , refer this old solution to increase connection timeout

https://community.powerbi.com/t5/Service/Timeout-Issue-Online-Redshift/m-p/1277076

[deew95]

@amitchandak thanks for your reply. But I can't increase the timeout with this command-> 

[CommandTimeout=#duration(0, 1, 0, 0)]

Also, there are only 4 rows in my data table which I'm using as a test dataset. What can I do to fix this?

Thanks in Advance.