I came across the error below from PBI Service but the same refresh works fine on the PBI desktop. On the PBI service it seems to run for 5 hours before it times out. Same refresh worked fine until last week even from the PBI service.
<pii>DataSource.Error</pii>: <pii>ERROR [HY000] [Microsoft][Hardy] (35) Error from server: error code: '0' error message: 'Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=8e521844-6949-4859-b3c2-b8fb4b81dd78]'.</pii>. . The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.
Any suggestions is appreciated. Thanks!