SSAS Restoring roles fails

If you encounter issues during a Power Update task that restores an Excel workbook to an SSAS Tabular database and the roles are not restored properly, use a custom xmla script to synchronize or create the roles after the restore.

The xmla script file containing the roles script can be specified in Advanced Properties\Actions\Arguments:

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

• SSAS Restore abf file access denied

  If you encounter an access denied error for the abf file during Power Update restoring an Excel Power Pivot workbook to an SSAS Tabular server, make sure that account that the SSAS windows service runs under has full access to ...

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

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