Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.


Consider the following scenario:

  • You install Microsoft SQL Server 2012 or SQL Server 2014 PowerPivot for Microsoft SharePoint 2013 on a SharePoint server. Or, you install SQL Server 2012 PowerPivot for Microsoft SharePoint 2010 on a SharePoint server.

  • The SharePoint server uses a fully qualified domain name (FQDN), as shown in Central Administration – Manage servers in the farm.

  • You try to update or refresh data in a PowerPivot workbook, such as the management dashboard.

In this scenario, you receive the following error message:

Unable to refresh data for a data connection in the workbook. Try again or contact your system administrator. The following connections failed to refresh: PowerPivot Data

Additionally, the following exception is logged in the SharePoint Unified Logging Service (ULS) log:

EXCEPTION: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.AnalysisServices.SharePoint.Integration.Redirector.CacheManager.ImageLoad(SPFile spFile , DateTime fileLastModifiedTimestamp, Int32 localeId, String databaseName, String databaseId, ImageLoadMode mode)

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


To work around the issue, use a NetBIOS name for the SharePoint server.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!