Power Update Command Line Parameters

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
number of miliseconds to wait until SharePoint processes restores the cube from the xlsx file (the file is uploaded as a temp file then renamed to it’s final name after that period)
-files:FILE_PATH
path for a txt file containing the files to refresh (one for each line, good for manual retries)
-macros_before:[“MACRO_NAME1 ARG1 ARG2..,MACRO_NAME2 ARG1 ARG2,..”]
list of macros to run before the update
-macros_after:[“MACRO_NAME1 ARG1 ARG2..,MACRO_NAME2 ARG1 ARG2,..”]
list of macros to run after the update
-wbpassword:PASSWORD
Workbook protection password
-timestamp
switch to include timestamp in file names
-email_to:[“EMAILADDRESS1, EMAILADDRESS2,..”]
target email addresses
-ssas_user:USER_NAME
SSAS user to impersonate using the EffectiveUserName connection string property on OLAP connections, NOT YET IMPLEMENTED
PU.exe command line (waits for exit and gives return code, 0 if ok, also used when impersonating a user)
C:\Program Files\PowerPlanner\Power Update\PU.exe “taskName”
Parameters
-runas
switch for impersonating a user (imersonation user / pass is defined in the task)

 

 

PURunas.exe command line (helper for running impersonating users, not used at the moment by PU)
C:\Program Files\PowerPlanner\Power Update\PURunas.exe “C:\Program Files\PowerPlanner\Power Update\PQRefresh.exe \”taskName\” …” “domain” “username” “password”

    • Related Articles

    • Power Update Maintenance

      Power Update is sold by a one-time fee that gives users a perpetual license to use the software forever. PowerON offers an optional maintenance contract in order to receive updates for the software. ​ Purpose of the document In this article, you will ...

    • 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 ...

    • Power SQL Update not loading in Excel

      Search the registry under both Current user and Local Machine for: PPSQLConnector and set the LoadBehaviour to 3 at all occurances e.g.: If the above doesn't resolve the issue, search for Addins in the registry under both Current user and Local ...

    • Use the same connection details for Power SQL Update in Dev and Production environments

      To use the same SQL connection in a dev and production environment, make sure the dev SQL server has the same instance name as the production one. Then you can use the hosts file in windows to map a server name to the actual server in each ...

    • Backup, Restore or Migrate jobs with Power Update

      Backup the files Back up your tasks regularly if you want to make sure you have a current set to restore if the machine has to be rebuilt, make a copy of the following files and directories: C:\Users\[USER]\AppData\Local\Power Update\Settings.xml ...