Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.