Hi All,

I have SharePoint 2013, SQL Server 2012 SP1, SSRS on SharePoint Mode and PowerPivot add-in.

I am facing the issue with Power View when "PowerView" icon is clicked.

I followed some of the instruction in the forum but still the problem is at large.

1. The C2WTS Windows service and C2WTS SharePoint service are both running

2. Checked the SQL Server Browser service is running on the machine that has the PowerPivot instance of SSAS.

3. I have Claims Based Authentication on my farm.

Error code is as given below though it remain the same.

Appreciate any help to fix the issue..

References taken to fix the issue

1. https://social.technet.microsoft.com/Forums/en-US/ecb0ca22-30ed-424c-b457-9972d3b5e8d6/excel-powerview-error-in-sharepoint-2013-an-error-occurred-while-loading-the-model-for-the-item?forum=sqlreportingservices

2. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/64ca0546-f5c4-4d33-95c1-1cf17ac789de/powerview-error-an-error-occurred-while-loading-the-model-for-the-item-or-data-source?forum=sqlreportingservices

3.https://social.msdn.microsoft.com/Forums/sqlserver/en-US/343880cc-080f-41f4-9036-2576733970c3/excel-powerview-error-in-sharepoint-2013-an-error-occurred-while-loading-the-model-for-the-item?forum=sharepointgeneral

Regards

Sakti

<detail><ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsCannotRetrieveModel</ErrorCode><HttpStatus xmlns="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 'https://abcd.abcd.com/sites/BI/ppg/QA-SSAS.xlsx'. 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">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">11.0.3000.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><MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices"><Source>ReportingServicesLibrary</Source><Message msrs:ErrorCode="rsCannotRetrieveModel" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsCannotRetrieveModel&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=11.0.3000.0" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">An error occurred while loading the model for the item or data source 'https://abcd.abcd.com/sites/BI/ppg/QA-SSAS.xlsx'. 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&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsErrorOpeningConnection&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=11.0.3000.0" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">Cannot create a connection to data source 'TemporaryDataSource'.</Message><MoreInformation><Source>Microsoft.AnalysisServices.SPClient</Source><Message>Call to Excel Services returned an error.</Message><MoreInformation><Source></Source><Message>We're sorry. We ran into a problem completing your request.</Message><MoreInformation><Source>Microsoft.Office.Excel.Server.WebServices</Source><Message>We're sorry. We ran into a problem completing your request.</Message></MoreInformation></MoreInformation></MoreInformation></MoreInformation></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" /></detail>

Hi Sakti,

Can you check the below link

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0be1ed0b-6b84-4d1b-962d-80462c9f266d/sql-server-2012-sharpointpowerpivot-an-error-occurred-while-loading-the-model-for-the-item-or?forum=sharepointadminpr

Hi Milan,

Thanks for the reply.

I checked the link and I would not like to change the deployment mode from Multidimensional as we need multidimensional.

With the same configuration(Deploymentmode-Multidimensional) it is working fine on my DEV environment.

Not able to figure out what is wrong in QA Environment, not allowing it to work ASIS as DEV.

Thanks

Sakti

Hi Sakti,

Thank you for your question. 

I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 

Thank you for your understanding and support.

Best regards,
Qiuyun Yu

If you have any feedback on our support, please click here.

Hi Qiuyun,

Thanks for the response.

I am not facing this issue in my DEV Farm and everything is ASIS in QA. But PowerView is throwing this error.

Appreciate your help if you can please expedite to fix this issue.

Regards

Sakti

Hi Sakti,

Based on my research, most common cause of this issue could be the following:

1. Permissions are not set properly.

2. Authentications are not set properly.

3. The PowerPivot instance hasn't been configured correctly.

Since you don't have issues in your DEV farm, you might have misconfigure one or more of those configurations in your QA farm.

If you cannot determine your answer here or on your own, consider opening a support case with us. Visit this link to see the various support options that are available to better meet your needs:  http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone.