locked
PowerPivot for SharePoint 2013 RRS feed

  • Question

  • Hi

    I have SQL Server 2014 and SharePoint 2013 installed in two different servers. I installed 'PowerPivot for SharePoint 2013' and Power Pivot confirguration tool in SharePoint server 2013. Data Refresh is working fine in Excel 2013 when I connect to SQL Server.

    But after I upload to SharePoint server 2013, data refresh is not working in browser. Also I tried installing 'PowerPivot for SharePoint 2013' in SQL Server 2013 server and running spPowerPivot.msi in SharePoint server and configuring it. It still didn't work. 

    Errors:

    1. Big red cross mark in PowerPivot management dashboard.

    2. 'Add this data to the Data Model' in Excel 2013 is not identifying the database and table selected in connection string.

    3. An error occurred while working on the Data model in the workbook. Please try again.

    4. Also it is complaining about "Cannot connect to the External Data Source"

    Please help to resolve. I also tried various options. Configurations are looking good. 

    Thanks in advance,

    Sujatha

    Monday, October 5, 2015 2:43 PM

Answers