This issue was fixed on January 22, 2025.

issue

 Intermittent error of "Refresh failed due to an unexpected error" when refreshing or creating a new connection.

See the below examples from the Excel Add-in 4.4

Note, this may impact the following add ins:

  • Excel Add in 4.4
  • Anaplan XL
  • PowerPoint Add in 1.8
  • Google Sheets
  • AM365

workaround

Ensure your model is loaded up ahead of signing into and using our add-ins. You can do this by first accessing the model in a browser.

If the issue persists, remake the sheet using a saved view (or default view in Excel 4.4). This issue doesn't appear when connecting to or refreshing saved views.

If you need more help, please visit our Support website to submit a case in the Support portal. A member of our Support team will be in touch to help you find a workaround.