Schedule Refresh Failed

[Anonymous]

Hi, 

I have tried to schedule a refresh but it says failed to refresh and the following is shown as the failure details
"Failure details: Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. "

The scedule refresh is working for less number of data rows. When it comes to huge rows it gives this error message. 

Can I get any suggesstion for this error.

Thanks in advance

[Pragati11 · Accepted solution]

HI @Anonymous ,

You can enter something into timeout session area while you connect to your datasource in Power BI.

Something like below:

You can enter 120 for starting in the marked section below and check if it resolves the issue.

Thanks,

Pragati

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

1. On the Power BI side, you could set 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.

Best Regards

Lucien

[Pragati11 · Accepted solution]

HI @Anonymous ,

You can enter something into timeout session area while you connect to your datasource in Power BI.

Something like below:

You can enter 120 for starting in the marked section below and check if it resolves the issue.

Thanks,

Pragati