cancel
Showing results for 
Search instead for 
Did you mean: 

Data refresh error

I scheduled a 3 refresh a day for my SQL dataset and I have regularly the following refresh failure - at least once a day. But the 2 other refresh are working. What's wrong ? It happens since 5 days

 

Processing error: Microsoft SQL: Server provided routing information, but timeout already expired.
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID: 49fe601b-92b2-4b6a-9f5f-1d170c0dfe36
Request ID: e671470d-bc6e-4b99-95d6-014234519411
Time: 2021-03-18 09:45:20Z

Status: New
Comments
CSART
New Member

@v-chuncz-msft 

I have no gateway, so no timeout setting.
I have 3 scheduled period a day : 6h, 10h30 and 15h
It failed always when the refresh is planned at 6h AM.
The schedule at 10h30 is sometimes successful, sometimes not (same for the refresh at 15h). When successful, the refresh takes about 14 minutes to complete -> why is it so slow ? My database contains only a few rows and the refresh through Power BI Desktop takes.... 10 seconds!
It seems very slow and very unstable.
 
 
 
Last refresh failed: Wed Mar 24 2021 06:17:12 GMT+0100 (Central European Standard Time)
There was an error when processing the data in the dataset.
Hide details
Processing error:Microsoft SQL: Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and respond; Or it could have timed out while attempting to create multiple active connections. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=18; handshake=26; [Login] initialization=0; authentication=0; [Post-Login] complete=29903;
Cluster URI:WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID:36caffe3-7749-4d93-be7f-719d3a61696d
Request ID:06f222ef-e6de-4486-8284-7b9141882b89
Time:2021-03-24 05:17:12Z