Big fan of this, but powerpivot sits on vertipaq (I believe) which is an in memory columnar DB or sorts (apologies if that’s incorrect). So at this point you’re getting awfully close to direct querying (another msft feature) which while analogous resembles more traditional db/client if you squint hard enough.
But yes, big fan of vertipaq which I believe also powers PowerBI.
But yes, big fan of vertipaq which I believe also powers PowerBI.