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.
