SSAS Restore abf file access denied

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 the C:\Users\[USER]\AppData\Local\Temp\Power Update folder:
- Go to Control Panel\Administrative Tools\Services\SQL Server Analysis Services\Properties\Log On
- Copy the account name (or user SYSTEM in case it's set to the local system account)
- Right click on the C:\Users\[USER]\AppData\Local\Temp\Power Update in explorer, Properties\Security, Edit, Add the copied account with Full access
    • 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 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 ...
    • 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 ...
    • Tasks not appearing

      If your a tasks are not visible, and adding new ones don't appear, the issue is usually due to one of the xml files becoming corrupted under C:\Windows\System32\Tasks\Power Update. Try removing them (or moving them to a different folder) one by one ...