Forum Discussion

EmiliaB_123's avatar
EmiliaB_123
Helper II
5 years ago
Solved

Export to Excel changes column names

Hello everyone, when I export my table from Power BI App to Excel part of the column headers get changed from "quantity" into "sum of quantity". I changed the headers in Power BI in order to have a ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi EmiliaB_123 ,

     

    Oh! Sorry for my misunderstanding!

    Please allow me to describe your issus again:

    When you export the visual data from apps to excel , the prefix of "Sum of " appears in the column name , and you have set the default summarization to "Sum", right?

     

    Now I could reproduce it! Please take a look at the differences:

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi EmiliaB_123 ,

 

Sorry for my late reply...Actually I'm confused about: this field is already set as "sum"

Did you mean that , the prefix of "sum of " still existed in the column in the exported excel file?

Did you try to re-export to see the changes?

Please share me with your pbix file from your Onedrive for Business after removing sensitive data. So that I could have a try again.

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

  • EmiliaB_123's avatar
    EmiliaB_123
    Helper II
    5 years ago

    Hi Anonymous ,

    you gave me the advise to change the value to "sum" and what I wanted to say is that it is already set as you gave me the advise to change it to. 

    I can´t share the file actually because the field related is already senstitive data.