Forum Discussion

Funk-E-Guy's avatar
Funk-E-Guy
Icon for Helper II rankHelper II
5 years ago

From PBI Desktop, how do you copy data in a Matrix visualization to be pasted into Excel?

I have my matrix set up so that it shows me 6 columns and ~1500 rows. But when I try to export, it tries to export the full dataset and tells me it's too large.   Due to an unrelated issue, I am cu...
Need Help
samdthompson's avatar
samdthompson
Icon for Memorable Member rankMemorable Member
5 years ago

PC2790 wouldnt it be easier to analyze in excel via a data connection which saves any combinations and limits?

 

PC2790's avatar
PC2790
Icon for Community Champion rankCommunity Champion
5 years ago

Yes, could be.

I did not try it at that time. Would be worth trying provided that the report is published in power BI service. I think in this case, it is not. Hence I suggested the manual approach.