An error occurred while loading the model for the item or data source ‘EntityDataSource’

I use SQL Server 2012 SP1 U8 and SharePoint 2013.

  • I configure Excel Service and Performance Point Service and PowerPivot Service.

  • I create an Excel File`that fetch data from Data Warehouse in PowerPivot report.

  • I load this file in Documents in my SharePoint web site.

  • When I click on my Excel file in SharePoint, I get this Error:

enter image description here

An error occurred while loading the model for the item or data source ‘EntityDataSource’. Verify that the connection information is correct and that you have permissions to access the data source.

rsCannotRetrieveModelhttp://www.microsoft.com/sql/reportingservices”>400 An error occurred while loading the model for the item or data source ‘EntityDataSource’. Verify that the connection information is correct and that you have permissions to access the data source. http://go.microsoft.com/fwlink/?LinkId=20476&
EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings& EvtID=rsCannotRetrieveModel&ProdName= Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=11.0.3401.0 Microsoft SQL Server Reporting Services 11.0.3401.0 127 OsIndependent xmlns=”http://www.microsoft.com/sql/reportingservices”> 1033http://www.microsoft.com/sql/reportingservices”> ReportingServicesLibrary msrs:HelpLink=”http://go.microsoft.com/fwlink/? LinkId=20476&EvtSrc= Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID =rsCannotRetrieveModel&ProdName= Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=11.0.3401.0″ xmlns:msrs=”http://www.microsoft.com/sql/reportingservices”>An error occurred while loading the model for the item or data source ‘EntityDataSource’. Verify that the connection information is correct and that you have permissions to access the data source. Microsoft.ReportingServices.ProcessingCorehttp://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc= Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings& EvtID=rsErrorOpeningConnection&ProdName= Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=11.0.3401.0″ xmlns:msrs=”http://www.microsoft.com/sql/reportingservices”> Cannot create a connection to data source ‘EntityDataSource’. Microsoft.AnalysisServices.SPClient We cannot locate a server to load the workbook Data Model. We cannot locate a server to load the workbook Data Model. Microsoft.Office.Excel.Server.WebServices We cannot locate a server to load the workbook Data Model.

I see this Power View Fails to Connect link but the answer does not work for me.

And this Link Power View Error: An error occurred while loading the model

Note: I can see all Excel report that does not have the PowerPivot component.