Amazon Redshift dataflow refresh failure

[Anonymous]

we are getting the Internal error in Power Service when dataflow refresh is happening 

Error captured in the power BI log is Timeout expired. The timeout period elapsed prior to completion of the operation.

source is Amazon Redshift 

any suggestions would be appriciated to fix this issue 

[Anonymous]

hi

wer are cconnecting to Redshift using the native connector( Redhshift on premise data gateway).

before 2 hours its failing

[GilbertQ]

Hi @Anonymous 

I would suggest following my blog post below and try and connect via ODBC?

Using Azure Analysis Services to connect via an ODBC Source (Redshift) - Reporting/Analytics Made easy with FourMoo and Power BI

[GilbertQ]

Hi @Anonymous 

Are you connecting to Redshift using the native connector or the ODBC connector?

I would look at making sure that your query can return data before the timeout occurs, which is typically 2 hours.