Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Export Report to Excel

Hi,

 

 

Is there any way to export report as it is in pivot table view in BI report? 

3 Replies

  • Anonymous you can export but it will not pivot, you have to pivot it wherever you are using exported data. I think there is an idea on this on ideas forum, please vote.

     

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

  • edhans's avatar
    edhans
    Community Champion

    No, but there is a new feature in Office 365 versions of Excel to get data right out of a Power BI report and create your own pivot.

     

    But you cannot copy and paste a pivot, or any other visual, to excel, unless you copy the visual as an image, which is also a newish feature.

    • Anonymous's avatar
      Anonymous
      Not applicable
      This option is not available in my excel
      Microsoft 365 update is not yet released in my organization