If you are using Excel 2010 and Power Query and have an issue during UI Automation, or if the task succeeds but the data doesn’t update please refer to the related article Otherwise please check the error messages in the C:\Users\[USER]\AppData\Local\Temp\PU.log file and turn on Options\Diagnostic Mode to see if Excel displays any popup messages during the update process and check for the symptoms below:
Read MoreTroubleshooting Excel 2010 UI Automation
If you are using Excel 2010 and Power Query datasources Power Update needs to perform UI automation. If UI automation fails for some reason please try the common resolutions below: Check if you can manually refresh the workbook and make sure all connections are working. If it’s a temporary / intermittent issue during refreshing connections, set the Retry Count and Retry wait settings in the
Read MoreBackup, Restore or Move jobs with Power Update
Backup the files We haven’t added any automated way to backup the settings file in Power Update. If you want to make sure you have a current set to restore if the machine has to be rebuilt, you can make a copy of the following files and directories: C:\Users\[USER]\AppData\Local\Power Update\Settings.xml C:\Windows\System32\Tasks\Power Update\ To Backup: 1. Copy the Settings.xml, including the path, to the backup drive,
Read MorePower Update Command Line Parameters
Running PU jobs in a batch file: After you have defined the jobs, you can take even more control over the jobs by i.e. running them sequentially in a batch job. Here are the command line parameters supported: PQRefresh.exe command line (normal tasks):C:\Program Files\PowerPlanner\Power Update\PQRefresh.exe “taskName” arguments: -log:FILE_PATH Path for the PU.log file -sp_overwrite_delay:NUMBER number of miliseconds to wait until SharePoint processes restores the
Read More