none
Connection from Excel to PowerPivot File in Sharepoint

    Question

  • Hello,

    I've uploaded a PowerPivot file to Sharepoint: PowerPivotDB.xlsx

    Now I want to build in a SEPARATE Excel file a dashboard that is connected to that PowerPivot file in Sharepoint

    I want my users to be able to analyze the dashboard both in Excel services (through web explorer) and in Excel itself (after clicking "Open in Excel" button in Sharepoint)

    When they try to open the DASHBOARD file in sharepoint they get ERROR message:

    Unable to refresh data for a data connection in the workbook.
    Try again or contact your system administrator. The following connections failed to refresh:
    PP_DB_CONNECTION.odc

    Please Help

    Thanks

    Michael Shparber


    Michael

    Thursday, March 21, 2013 3:21 PM

Answers

All replies