Matrix Data Export to Excel lose Formating

[BradRose]

Good Afternoon:

I want to export a martix from Power BI to excel, PDF will not meet my users needs.  When I click on the 3 dots and choose Export data I only ge the option Summarized Data.  When I  Export the data the Months are now a column instead of being accross the top of the report.  Is it possbile to maintain the same format?  i am looking to create all the reporting needs in Power BI vs having to use both Power BI and Power Query

Thanks

Brad

Before

After

[v-cherch-msft · Accepted solution]

Hi @BradRose 

"Export data' will export the raw data(original table) to csv file, not the format of a matrix data. As a workaround, you may try File-> Export to PDF instead in power bi desktop.The other workaround,please refer to this similar post.

Regards,