Forum Discussion
Online refresh fails with Amazon Reshift
Hi All,
I am using Amazon Redshift views as backend in my Power BI report . The refresh works in the Power BI desktop (takes one hour to refresh 1 million records). But in the Power BI online the refresh fails with time out exception. Even tried increasing the timeout to 180 mins , but it failed once again with timeout exception.
| Message: | Timeout expired. The timeout period elapsed prior to completion of the operation. Table: monthly_datasource. |
| Cluster URI: | WABI-NORTH-EUROPE-redirect.analysis.windows.net |
| Activity ID: | ba260a3f-79f4-45d8-a0e3-c9a850a50e91 |
| Request ID: | ec437539-9d77-2834-57d5-bbaaeccc69b2 |
| Time: | 2019-01-15 11:58:20Z |
Can anyone please tell me how to resolve this issue , i need this refresh to work online.
Regards
5 Replies
- ncbshiva
Advocate V
Hi All,
Can you please help me to resolve this refresh issue ?
- v-yuta-msft
Community Support
Please check if the credentials is invalid or expired, click dataset-> Data Source-> Credentials.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- ncbshiva
Advocate V
Hi v-yuta-msft,
The credentials are valid indeed and working fine , when i try to refresh the same in the Power BI Desktop.
- ncbshiva
Advocate V
Hi Team,
Can you please help me to resolve this refresh issue with Amazon redshift , i have been facing this since 2 months and i am not able to get the where the problem is.
Regards