Indeed you are correct - with the current implementation of RadPivotGrid
for WPF the whole data is extracted from the cube initially. The extraction is not related to the expand or collapse state of the groups.
We have a feature request logged in our Feedback Portal:
where you can track its status and vote for it.
Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer
and share your thoughts.