Forum Discussion
Copy and paste matrix visualization in Excel
Hello,
Please, I need help on Power BI Service.
I have many matrix visualisations in reports and I need copy and paste matrix table in Excel keeping the same format as in my Power BI report.
I tried all of the copy and export features and still en up with flat data...
Here's what I'm looking for :
Matrix in Power BI
Matrix PBI
Expected result in Excel
I can't recreate pivot table in Excel because the calculation of values and totals is fully dynamic relative to the displayed lines... and I have a lot of different matrix with different columns and rows.
Thanks in advance for your precious help,
Best regards,
Marine
Sorry for my English !!
Hi marine_chf ,
Please try to use Analyze in Excel. Then, you could copy your report in Excel.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi marine_chf ,
Please share me some sample data, removing sensitive information, for test.
Best Regards,
Icey
Hello Icey,
Thanks for your answer.
You will find examples at the following URL :
If you don't have access, I can send you pbix file ?
Best Regards,
Marine
Hi marine_chf ,
Oh, I have no access.
Please share me a dummy PBIX, removing sensitive information and replacing real data with dummy data.
It is suggested to upload your file to OneDrive for Business and then paste the link here.
Best Regards,
Icey
Hi marine_chf ,
Please try to use Analyze in Excel. Then, you could copy your report in Excel.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
