I’m cleaning out some things I marked to review and I see that I failed to highlight Vaidy’s article on Stored Procedure as Data Source in PowerPivot.
Stored Procedure as Data Source in PowerPivot – Issue & Solution – Microsoft Dynamics GP Learn & Discuss –
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.