Activate license using License key

After purchasign a license, you will receive a license key After downloading and installing the software, you need to activate the software in the Options\Activate menu button. To activate the software enter your license key (if the license key option is not available, you are probably using an old version of the software, in this[…]

Troubleshooting Excel PowerPivot Update

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[…]

Troubleshooting 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,[…]

Backup, 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.[…]

Power 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[…]