Excel 2016 No model found, or XmlaClient error

Excel 2016 No model found, or XmlaClient error

If you are using Excel 2016 Power Update needs to use a different set of libraries to connect to your Excel Data Model. Normally Power Update sets this automatically, but in some cases it fails to do so due to lack of permissions, or multiple Excel versions previously installed.

In this case you’ll need to copy the contents of C:\Program Files\PowerPlanner\Power Update\xl2016 to C:\Program Files\PowerPlanner\Power Update (back up the files to an C:\Program Files\PowerPlanner\Power Update\xl2013 folder before overwriting them).

In some cases installing these Microsoft components also resolve the issue:

    • Related Articles

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

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

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

    • Troubleshooting Excel 2010 UI Automation

      If you are using Excel 2010 and Power Query data sources 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 ...