Forum Discussion

ncbshiva's avatar
ncbshiva
Icon for Advocate V rankAdvocate V
7 years ago

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

  • Hi All,

     

    Can you please help me to resolve this refresh issue ?

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support

    ncbshiva,

     

    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's avatar
      ncbshiva
      Icon for Advocate V rankAdvocate 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's avatar
        ncbshiva
        Icon for Advocate V rankAdvocate 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