Microsoft SQL: Execution Timeout Expired.

[kobik]

Hi,
since we made a maintanance on our server (nothing was changed) we are incountering with this error
on average for the biggest cube the refresh time was 45 minutes...
what could possibly be the reason ?

[jennratten · Accepted solution]

On the Power BI side, you could set the timeout option and check again. The maximum is 2 hours.

2. On the SQL side, you could use SSMS to check if there is a lock on one or more tables.

    If your data is large, you could create views to optimize data size. 

    It is recommended to update the Connection Timeout and Command Timeout parameters in the relational Target Connection.