Forum Discussion

BradRose's avatar
BradRose
Helper I
7 years ago
Solved

Matrix Data Export to Excel lose Formating

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

 

 

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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,

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    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,