No external data source when I try to data refresh the powerpivot sheet RRS feed

  • Question

  • Expert,

      I created a PowerPivot worksheet that data come from ERP database, then I upload to SharePoint 2013 PowerPivot apps, when I tried to run "Manage Data refresh", system show error message "A Schedule cannot be enabled for a worksheet with no external source". does anybody can let me know why ? or I need to run SharePoint Designer to add the external source. if it is, how to connect to MSSQL ?

    James Liang

    Tuesday, May 5, 2015 11:57 PM


All replies