cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
deew95
Frequent Visitor

Connecting AWS Redshift to Power BI

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.

deew95_0-1656514349242.png

 

Thanks in Advance.

 

2 REPLIES 2
amitchandak
Super User
Super User

@deew95 , refer this old solution to increase connection timeout

 

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



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s || 50+Power Query List Functions : Learn Power Query List
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

@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.  

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors