Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How To set a TImeout in Redshift

Hey guys, Since last week I constantly get a timeout error on m Power BI model. I have no idea why it times out after 7-10min. It never happened before (Redshift has been connected to PBI for last 2...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous 

This is the format format for general SQL datasources, for RedShift try add the batchsize option in the code.

Please refer to: Solved: Timeout Issue Online - Redshift - Microsoft Power BI Community

 


Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I did try that it worked for a couple of refreshese and again I get a timeout but this time due to the fact it takes more than 120min.

    What I don't get is why sometimes PBI takes only 205-45min to complete a refresh and sometimes it gets stuck and times out after 120min. Is it because the redshift connector needs to wait for redshift to complete its own refresh before it can "grab" the data?