Forum Discussion
Helper IIExport summarized data to excel not showing visual level user friendly names
Hi all,
I observed a weird behaviour while exporting summarized data to excel from Power BI online matrix visual. Column names in the excel are not matching with the user friendly names given on the visual rather exporting the original table column names. This is not happening for all the columns, Some columns are exported with their respective visual level names.
I want users to download user friendly names while exporting summarized data to excel.
Any help is highly appreciated.
Hi ksivaganesh99 ,
When you export to Excel, if you have an alias for a field name and there is more than one field with that name, Excel will revert to the original column name. It may also depend on WHERE you renamed it - if you just renamed it on that visual, then the original column name will be used. You can try making sure that there are no duplicate column names and/or change the column name in the table/query and see if that carries through.
Also, you can try exporting to .csv rather than .xlsx and see if that keeps the alias names.
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
1 Reply
- collinq
Super User
Hi ksivaganesh99 ,
When you export to Excel, if you have an alias for a field name and there is more than one field with that name, Excel will revert to the original column name. It may also depend on WHERE you renamed it - if you just renamed it on that visual, then the original column name will be used. You can try making sure that there are no duplicate column names and/or change the column name in the table/query and see if that carries through.
Also, you can try exporting to .csv rather than .xlsx and see if that keeps the alias names.
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!