PawnofGod on Thu, 06 Oct 2016 17:59:31
PowerPivot has been successfully setup on AppServer1. Data refresh is working and the timer jobs are running. I configured APPServer2 for PowerPivot and when PowerPivot runs on AppServer2 alone, PowerPivot successfully runs the workbooks and they are loaded into Analysis Services, but the Data Refresh timer job doesn't run. At least, there is no indication that it did run. If I run the job manually it doesn't fail but it doesn't show as successful either. Workbooks are not getting refreshed. Any thoughts would be appreciated.
Dean_Wang on Fri, 07 Oct 2016 01:49:30
Please view Job History in CA after you run PowerPivot Data Refresh timer job. Then provide screenshot about the PowerPivot Data Refresh timer job status here.
And provide error message in ULS logs.
ULS viewer is a good tool to check for ULS logs: