Forum Discussion
Column name changed while exporting of table into .xlsx format
Hi,
I am trying to export "summarized data" from a table in .xlsx format.
In the exported excel file, one column name is showing "Table_Name[Column_Name]" instead of the column name defined. Although, I tried to export the other tables but the columns name of those tables are same as expected.
Does anybody know why the column name is exporting as "Table_Name[Column_Name]" and how to fix it ?
Any suggestion on this is really appreciated.
Best Regards,
Ankbaner
hi, Anonymous
I have tested on my side, but not reproduce the issue.
For example:
Does that happen in other reports? If you try to republish this report?
And if possible, could you share this sample pbix file for us have a test?
Best Regards,
Lin
4 Replies
v-lili6-msftCommunity Support
hi, Anonymous
I have tested on my side, but not reproduce the issue.
For example:
Does that happen in other reports? If you try to republish this report?
And if possible, could you share this sample pbix file for us have a test?
Best Regards,
Lin
Hi v-lili6-msft
Thank you for your reply. There are some sensitive data due to which I cannot share the exact PBIx file. Therefore, I tried to reproduce the issue again and test the export to excel sheet from PBI service. The exported file contains the expected column name instead of “Table_Name[Column_Name]”.
Best Regards,
ankbaner
- v-lili6-msft
hi, Anonymous
I suspect that it is a temporary issue, now it works well.
Anyhow It's pleasant that your problem has been solved, could you please mark the reply as Answered to close the thread? :smileyvery-happy:
Best Regards,
Lin