Power SQL Update not loading in Excel

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 Machine, and if you find any path in the registry that contains Excel\Addins but there's no PPSQLConnector folder under it or there's no LoadBehaviour dword set to 3 under the PPQSQLConnector folder, then create the PPSQLConnector folder and the LoadBehaviour dword set to 3.
    • 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 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 ...
    • 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 ...
    • 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 ...