Configuring Excel Power Refresh for SQL Agent Jobs

Parent Previous Next


Configuring Excel Power Refresh for SQL Agent Jobs


Excel Power Refresh within a SQL Agent Job must be done by using a proxy account. Please use the following steps prior to configuring your SQL Agent Job:


1.  Create a credential based on your login (found within the Security folder in SSMS):




2.  Create a proxy account based on the previously created credential. Select the SSIS Package Integration Services Package subsystem:



3.  Set the job step to run as the proxy account:



4.  Start the job.


5.  If you receive the following error: "Code: 0x00000000     Source: TF Excel Power Refresh Task ExecuteTask Failed:     Description: Microsoft Excel cannot access the file <path>.xlsx'. There are several possible reasons:    ? The file name or path does not exist.  ? The file is being used by another program.  ? The workbook you are trying to save has the same name as a currently open workbook.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  1:28:39 PM  Finished: 1:28:44 PM  Elapsed:  4.735 seconds.  The package execution failed.  The step failed."


This issue can be resolved by adding a Desktop folder to the following directories:

C:\Windows\SysWOW64\config\systemprofile\

C:\Windows\System32\config\systemprofile\




6.  Restart the job.