Hi Jason,
Check your datasource and connection string. If the datasource is able to connect properly then it should work. Check also if the stored procedure has any parameters.
Stored procs are not related to ASPxPivotGrid. They are processed on behalf of the datasource (e.g. SqlDataSource).