Forum Discussion

perfectreign's avatar
perfectreign
Frequent Visitor
2 years ago

Data Are Exporting to Excel as Pivot Table?

Hi - I'm fairly new to PowerBI.  I have a report, which I plan to use online. Some of my users want to export it to Excel.

When I do, I get a pivot table. This is not what they want. 

 

 

I looekd and saw this thead: Solved: Export pivot table to excel - Microsoft Fabric Community

 

How do I export just to Excel as a table without the pivot?

 

 

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    perfectreign , On Power BI service, when you will click on export, you should see a few options . You are looking for Summarized data option

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you. I do not see this. All I see are Analyze in Excel, PowerPoint, and PDF.