locked
Error while refreshing Excel 2013 in Sharepoint 2013 powerpivot site with SQL Server 2008 RRS feed

  • Question

  • Hello,

    Sharepoint 2013 installation in farm mode, SQL 2008  installed .

    Powerpivot addin installed for sharepoint 2013. COnfigured the Secure store service to domain account, configured unattended refresh account. Configured data model setting for Excel services.But still I get the below error.

    "Data Model Can not be refreshed."



    Monday, May 20, 2013 12:35 PM

Answers

  • Hi Sonu,

    Are you useing SQL Server 2008 in your SharePoint farm?  The minimum requirements of SharePoint 2013 for a database server in a farm:
    One of the following:

    • The 64-bit edition of Microsoft SQL Server 2012.
    • The 64-bit edition of SQL Server 2008 R2 Service Pack 1

    For more information, please see:
    Hardware and software requirements for SharePoint 2013: http://technet.microsoft.com/en-us/library/cc262485.aspx#section4

    SQL Server 2012 Service Pack 1 (SP1) is a version of Microsoft SQL Server 2012 that supports Microsoft SharePoint 2013 Excel Services usage of Excel workbooks containing data models and Reporting Services Power View reports. In your case, we need to install SQL Server 2012 SP1 in our SharePoint farm environment.

    For more information, please see:
    Install SQL Server BI Features with SharePoint 2013 (SQL Server 2012 SP1): http://technet.microsoft.com/en-us/library/jj218795.aspx
    PowerPivot Data Refresh with SharePoint 2013 and SQL Server 2012 SP1 (Analysis Services): http://technet.microsoft.com/en-us/library/jj879294.aspx

    Best Regards,


    Elvis Long
    TechNet Community Support

    • Marked as answer by Elvis Long Thursday, May 30, 2013 1:44 AM
    Wednesday, May 22, 2013 3:28 AM