Export into excel file as Matrix table format

[amadrid3]

Dears,

I have matrix table created in my Power BI reports and I would like to ask if there's a away to export them into excel as same as Matrix table not a tabular table which is the current behaviour of export to excel?

Thank you in advance!

Albert

[v-lili6-msft]

hi  @amadrid3 

To my knowledge, it is not available in power bi for now.

here is the idea, you could see more details and vote for it:

https://ideas.powerbi.com/ideas/idea/?ideaid=b33fc4b3-9dae-4356-973d-d5ffe635ce15

https://ideas.powerbi.com/ideas/idea/?ideaid=4f364130-6d79-43ff-939b-a58c9939939b

Regards,

Lin

[amadrid3]

Thanks Lin for the feedback. I've voted on the two links above. Hope this feature will be available soon. 

Regards,

Albert

[amadrid3]

Hi Lin,

Do you have any alternative workaround while waiting the Microsoft to implement this feature?

Regards,

Albert

[sfmike99]

I just checked that feature request, and to my delight it has moved to 'planned' status. 

I've tried using export to Excel but the limitations are too onerous (relationships don't carry over so you have to have everything in measures).

This Chrome extension seems like a good workaround if it's legit:

https://medium.com/bi-helper/table-and-matrix-data-exports-to-match-power-bi-visual-bb7aa3213016

https://bihelper.tech/bihelper_matrix.html#guide