Я использую SQL Server 2012 SP1 U8
и SharePoint 2013
.
Я настраиваю Excel Service
и Performance Point Service
и PowerPivot Service
и...
Я создаю Excel File
, который извлекает данные из DataWare House
в отчете PowerPivot
.
Я загружаю этот файл в Documents
в моем Share Point Web Site
.
Когда я нажимаю на свой файл Excel в SharePoint, я получаю эту ошибку:
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.
<detail><ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">
rsCannotRetrieveModel</ErrorCode><HttpStatus mlns=
"http://www.microsoft.com/sql/reportingservices">400</HttpStatus>
<Message xmlns="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.</Message><HelpLink
xmlns="http://www.microsoft.com/sql/reportingservices">
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
</HelpLink><ProductName xmlns="http://www.microsoft.com/sql/reportingservices">
Microsoft SQL Server Reporting Services</ProductName>
<ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">11.0.3401.0
</ProductVersion><ProductLocaleId xmlns
="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId>
<OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">
OsIndependent</OperatingSystem><CountryLocaleId
xmlns="http://www.microsoft.com/sql/reportingservices">
1033</CountryLocaleId><MoreInformationxmlns=
"http://www.microsoft.com/sql/reportingservices">
<Source>ReportingServicesLibrary</Source>
<Message msrs:ErrorCode="rsCannotRetrieveModel"
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.</Message><MoreInformation>
<Source>Microsoft.ReportingServices.ProcessingCore</Source><Message
msrs:ErrorCode="rsErrorOpeningConnection" msrs:HelpLink=
"http://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'.
</Message><MoreInformation><Source>
Microsoft.AnalysisServices.SPClient</Source><Message>
We cannot locate a server to load the workbook Data Model.</Message>
<MoreInformation><Source></Source><Message>
We cannot locate a server to load the workbook Data Model.</Message>
<MoreInformation><Source>Microsoft.Office.Excel.Server.WebServices
</Source><Message>We cannot locate a server to load the workbook Data Model.
</Message></MoreInformation></MoreInformation>
</MoreInformation></MoreInformation>
</MoreInformation>
<Warnings xmlns="http://www.microsoft.com/sql/reportingservices" /></detail>
Я вижу эту ссылку Power View Fails to Connect и делаю этот ответ, но это не работает для меня?
и эта ссылка Ошибка PowerView: произошла ошибка при загрузке модели
Примечание. Я вижу все отчеты Excel, в которых нет компонента PowerPivot
.