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.
I created a matrix with few measures in my power bi desktop.
I renamed all the measures to Hebrew. when I export this matrix to excel, some of the measures use my rename field name and other measures use the original field name.
- I changed the field name using "rename for this visual"
why exporting matrix to excel do not show the new field name I entered?
Try changing in Table view located on left side bar. This works for me
Hi, @orbe
Have you checked the Limitations and considerations of Export data?
In Power BI, you can rename a field (column) by double-clicking the field and typing a new name. Power BI refers to the new name as an alias. It's possible that a Power BI report can end up with duplicate field names, but Excel doesn't allow duplicates. So when Power BI exports the data to Excel, the field aliases revert to their original field (column) names.
Related thread:
Export-summarized-data-to-excel-not-showing-visual-level-user
If it does not apply to your current situation, please provide more information for testing.
Best Regards,
Community Support Team _ Eason
HI,
Thank you for referring me to the limitation and consideration
And to the related thread.
Unfortunately, it was not helpful.
My new field names does not repeat it self
And I do not see a reason to this behavior.
I hope you can help me find the reason why my field name change to the original name
I attached pic of the problem
Hi, @orbe
Sorry, I can't find any problems from your current screenshot.
Have you tried uploading the pbix file to the powerbi service, and then exporting the data on the powerbi service?
Maybe it will be different.
Best Regards,
Community Support Team _ Eason
Hi,
I have the latest Power Bi version
My Power Bi Ver : 2.92.706.0 64-bit
All the Names For the matrix Visual is in Hebrew but when I export it to excel part of it display the original name in English.
I do not see any difference between the measures that it name display in English and the measures that it name display in Hebrew
@orbe
This behavior is somewhat strange. I would like to suggest, you better open a support ticket on this issue, they respond promptly. Hope you are on Pro License.
https://powerbi.microsoft.com/en-us/support/
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@orbe
I tested the same and all my measures had the new field names when exported to Excel. Can you update your Power BI desktop version if it not done so and try?
Please recheck your measure on a table visual
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Unfortunately, the problem still occurs (i updated the version)
I had the same problem this morning. Turns out I was using the "Live Connection" option instead of the normal one and that resolved the issue for me.
Hi orbe,
Did you ever figure out why this was the case? I'm having the same problem where upon exporting to Excel, it is using the actual calculated column names instead of the aliases specified in the visual's fields list (multi-row card). There's no duplicate names in play and it only does it for some of them.
Thanks,
Chris
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.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |