Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Table export formatting problems

I have an issue from Exporting to excel as 'summarised data' causes column headers change therie name as original column name for a single column

It should be only Market. It is working correctlty at my end but end user repeatedly facing this issue. 

Thanks

 

Need Help

8 Replies

  • Thejeswar's avatar
    Thejeswar
    Super User
    4 years ago

    Hi Anonymous ,

    The Export data as Summarized data by default exports the data with column names shwing the Aggregation applied.

     

    Instead, if you are displaying the summarized data in your report, you can export the data by selecting the "Data with Current Layout" option. That will download the visual with the Column days that are displayed in the report

     

    Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks for your response. I have tried all the option and it is working perfectly at my end but end user have the problem and their is no aggregation on particular column which is showing original name. Please suggest.

      • Thejeswar's avatar
        Thejeswar
        Super User
        4 years ago

        Hi,

        Is there any renaming of Columns that was done from the Power BI service after publishing the report to Power BI Service?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    No, it remain same from starting

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous 

    Does this happen to all your end users? Or is it just some end users who have this problem when exporting? I tested the scenario you described, and the column headers of the exported data are the same and have not changed . You can first judge whether it is an individual user problem or a general problem .

     

    Best Regard

    Community Support Team _ Ailsa Tao

    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
      4 years ago

      Everything working fine at my end but some of my end user repeatedly facing this issue. It is not an individual problem. I have done to use Reset report and also delete cookies from their system but nothing resolve. Please suggest me.

      • Thejeswar's avatar
        Thejeswar
        Super User
        4 years ago

        Hi Anonymous ,

        From what you say, it doesn't seem to be a general problem. Only specific users are having this issue while others are getting as expected.

         

        Then in such case, this could be some browser property setting that is causing this. Try to understand which of their browser setting is different from yours. That might crack the reason behind this issue. I don't get to think of any possible reason that can cause this. Of course, have never come across something like this until now