Forum Discussion

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago
Solved

Copying data from matrix visual

Hi all,   Imagine we have a matrix visual in our report, with a field in rows and several measures. I would like to copy that data and paste it somewhere else. I see there is an option to export th...
Need Help
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
7 years ago

Once you have published your report to the PowerBI service you will have more Excel as an export option and Summarized data is everything in the visual.  Is that what you are looking for?

 

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

    Hi jdbuchanan71

     

    Thanks for your reply.  I'm actually talking about Power BI Desktop rather than the service.

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

      Hi AlB,

       

      I would suggest you vote up this idea.

       

       

      Best Regards,

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

      Do you only need the data or also how you arranged it in matrix?

       

      I had encountered a scenario with my collegues where the positions of exported data is different from the matrix. 

      Since matrix is a visual, what we can only export is the data inside the matrix.

       

      What we did is we saved the page, where the matrix is, in pdf then converted it to excel.

       

      Take note that the matrix must show all data. You can adjust the page size.