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!
... View more