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:

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&amp;
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.

2 Answers
2

This is permission issue. You have restricted the user and your model using Window Authentication so that it can not be able to consume data from the model. Give specific rights to user group then this will be resolved.