cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
trungnguyen0000
Helper IV
Helper IV

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

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

1 ACCEPTED SOLUTION
timg
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

4 REPLIES 4
timg
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

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 !

 

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi Timg,

Thank you for taking time to answer me😀

 

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

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors