locked
PowerPivot Report in SharePoint RRS feed

  • Question

  • Hi 

    I've installed BI features in SharePoint. When upload or create a SSRS report then it works successful. However, my problem is with PowerPivot. For instance I've uploaded a PowerPivot report as a WebPart and other one as a document. When I try to open them I get the following errors . Please have a look. 

    Thanks in advance. 


    KAdir

    Monday, December 9, 2013 10:40 AM

Answers

  • Hi KAdir,

    Based on your description, it issue can be caused by that there was no POWERPIVOT instance under the Excel Services Data Model Setting. If your organization uses the client application, PowerPivot for Excel, to create workbooks that contain analytical data, you must have PowerPivot for SharePoint to access that data in a server environment. Please ensure that you have install PowerPivot for SharePoint and added this Server\POWERPIVOT entry to the Excel Services Data Model Settings.
    Reference: Install PowerPivot for SharePoint

    Regards,
    Charlie Liao

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


    Charlie Liao
    TechNet Community Support

    • Marked as answer by Charlie Liao Wednesday, December 18, 2013 1:26 PM
    Tuesday, December 10, 2013 6:35 AM