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

Important: In Excel for Microsoft 365 and Excel 2021, Power View is removed on October 12, 2021. As an alternative, you can use the interactive visual experience provided by Power BI Desktop, which you can download for free. You can also easily Import Excel workbooks into Power BI Desktop

Symptoms

Consider the following scenario:

  • You create a PivotTable report in a Microsoft Excel workbook by importing data from Microsoft SQL Server 2012 Analysis Services (SSAS 2014).

  • You upload the Excel workbook to a PowerPivot Gallery in SharePoint Server 2013.

  • You open the PowerPivot Gallery.

In this scenario, the Create Power View Report button in the upper-right corner of the Excel workbook is visible and enabled, even though the workbook does not contain a data model. Additionally, when you click the Create Power View Report, you receive the following error message:
 

An error occurred while loading the model for the item or data source "<path>"
Verify that the connection information is correct and that you have permissions to access the data source.

Resolution

The issue was first fixed in the following SQL Server cumulative updates: 

Cumulative Update 8 for SQL Server 2014

Cumulative Update 1 for SQL Server 2014 SP1

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

Status

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

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!

×