Export data- column header name changed when a filter is used

[Anonymous]

Hi guys,

I have a table with severals column

A |B |Unity |C |D

There is a filter in the same page to select values of Unity. When I use this filter and export data to xlsx , the name of this column in the excel file has been changed to 'TabName'[Unity].

I would like that it displays only Unity

I tried to change the name of the column in the VALUES part of the table in Desktop.  I changed it to Unity Test and the problem is resolved. After that, I rechange to Unity and the problem came back.

I tried to change the name of the field on Power Query to Unity xxxx, put it in the table and change the name of the column to Unity but it didn't resolve the problem.

Do you know why and where can I unable this automatical change ? I will appreciate others solution If you have.

Thank you

[timg · Accepted solution]

Hi,

This can happen when the same name occurs multiple times. Since Excel does not support duplicate names it will automatically add the alias to the name to avoid doubles.

Regards,

Tim

[Anonymous]

Thanks for the clue. In fact, my data tables has many same fields that's why the export change the name of the field to distinguish. I changed their name and it worked !

[timg]

Awesome, good to hear you were able to find the cause!

[Anonymous]

Hi Timg,

Thank you for taking time to answer me😀

I don't think so because the table contains only one column Unity