Forum Discussion
From PBI Desktop, how do you copy data in a Matrix visualization to be pasted into Excel?
Hello Funk-E-Guy ,
I faced the same problem in my project and to fix that, I used a slicer with the Slider option as on. You can put any quantitave field in the slicer. For Example: I used volume sin there.
And then I figured out the optimum threshold after which the export breaks with the error.
It was generally 7000-8000 in my case.
After the extraction, I combined all the excels seprately for the required job.
I am not sure if it is an efficient way of doing it, but it worked for me.
PC2790 wouldnt it be easier to analyze in excel via a data connection which saves any combinations and limits?
Due to an unrelated issue, I am currently unable to publish my model to our company workspace. Therefore, I cannot powerquery the model from Excel as a workaround at this time.
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.
