Forum Discussion

Baskar's avatar
Baskar
Resident Rockstar
8 years ago
Solved

SSAS Connection timeout issue

Thanks Advanced,

 

In my report am using two source.

1.SSAS (DAX code)

2. OLEDB ( It is function)

 

Scenario : 

  DAX is primary source, here we have 925 records( Execute time less then 1 mins).

  In next process we are involking OLEDB function into DAX output. Approximatly we are getting 100 records for single DAX row.

 

While doing this process am getting SSAS connection Timeout issue. 

 

Help me to come out from this issue.

 

 

 MattAllington

  • Hi Baskar,

     

    Can you share more details?

    1. Is it Import mode?

    2. What's the OLEDB function?

    3. How long did the second step run?

    4. Can you add more time to the timeout parameter?

    SSAS_Connection_timeout_issue

     

    Best Regards,

    Dale

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi Baskar,

     

    Can you share more details?

    1. Is it Import mode?

    2. What's the OLEDB function?

    3. How long did the second step run?

    4. Can you add more time to the timeout parameter?

    SSAS_Connection_timeout_issue

     

    Best Regards,

    Dale