cancel
Showing results for 
Search instead for 
Did you mean: 

Dataset schedule refresh fails intermittently.

Hi Team,

 

I have one Power BI Dataset which is connected to the Azure Database. I have scheduled refresh for five times a day. Out of five times, it works 3 times but fails two times. If I try to refresh manually by Refresh Now option it works completely but by schedule refresh, it is failing. 

 

I try to troubleshoot by different combinations like time, table of connection but could not get any clue. In Refresh history, I found two types of issues as follows.

Error 1 - 

{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"An error happened while reading data from the provider: 'Internal .Net Framework Data Provider error 6.'"}}],"exceptionCulprit":1}}} Table: XXXX.

 

Error 2 -
{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"Microsoft SQL: Server provided routing information, but timeout already expired."}}],"exceptionCulprit":1}}} Table: XXXX.

 

Please suggest any solution to fix this issue.

 

Thanks!

Status: New
Comments
Community Support

@ssangekar 

 

Take a look at Troubleshoot refresh scenarios and create a support ticket for assistance if necessary.