Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Export to Excel Power BI report

Hi 

 

I have created Power BI report which looks like following one. I am using matrix visual to show data wherein I am showing Employees on rows and Year, Month on columns. But when I am exporting this report into excel, exported report in excel is not showing up same as matrix report however all months are also coming on rows. Is it possible to export the report exactly same as Power BI matrix report ?

 

Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous unfortunaltey not, it converts it into table. check on ideas forum if there is a idea for it (i think there is one) and vote for it. if not then create new idea.

4 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    Anonymous unfortunaltey not, it converts it into table. check on ideas forum if there is a idea for it (i think there is one) and vote for it. if not then create new idea.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks !!

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

        Hi Anonymous 

        Kindly mark the helpful answer as a solution to close this thread.

        Regards,

  • mussaenda's avatar
    mussaenda
    Icon for Community Champion rankCommunity Champion
    7 years ago

    There is a way if you really want to. You need make your report in one page where you can see all your data. Then export to pdf. It is okay if your font size will be small. After exporting to pdf, convert it to excel using online tool.

     

    It requires an effort but worth it if you really need it.