Copy and paste matrix visualization in Excel

[marine_chf]

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 !!

[Icey · Accepted solution]

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.

[Icey]

Hi @marine_chf ,

Please share me some sample data, removing sensitive information, for test.

Best Regards,

Icey

[marine_chf]

Hello @Icey,

Thanks for your answer.

You will find examples at the following URL :

https://app.powerbi.com/groups/f5cb184f-b7a2-492b-ba6e-6e1e7b2c87fd/reports/f9ca9e6e-32cf-4732-9662-...

https://app.powerbi.com/groups/f5cb184f-b7a2-492b-ba6e-6e1e7b2c87fd/reports/d4dfe1d2-3b51-42f3-bf92-...

If you don't have access, I can send you pbix file ?

Best Regards,

Marine

[Icey]

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

[marine_chf]

Hello @Icey ,

Sorry, I didn't think about OneDrive...

Here's the link :

The are two example files. All sensitive data has been removed.

Thanks,

Best Regards,

Marine