5

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.

0

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.

-1

You need to recycle the Security token app pool.

  • Can you please add more details to this answer about how to accomplish what you propose? – Robert Lindgren Oct 30 '14 at 18:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.