PCA of probability measures: Sparse and Dense sampling regimes