Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
Proud to be a Datanaut!
Private message me for consulting or training needs.
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.
Proud to be a Datanaut!
Private message me for consulting or training needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.