Export Data in Excel not formatted.

[Anonymous]

Hello PowerBI gurus,

Hope you all are doing well. I am looking for some help around excel formatting when exporting the data. I have a table in my PowerBI report, when I export the data into excel, the column name is not formatted properly, the entire name is not visible instead its shrinked, is there any workaround to fix this?

Report:

Excel export:

Appreciate any leads or help.

Thanks in advance. Have a great day !

[v-xinruzhu-msft]

Hi @Anonymous 

1.When you export data in this visual, you can't control the width of the table columns when the data is imported into Excel, and the best way is to manually lengthen the table width after the data is imported into Excel.

从 Power BI 可视化效果导出数据 - Power BI |微软学习

2.Excel列对显示字符有限制。它支持 255 个字符，列中的字符包含太多空格，请尝试减少空格，然后导出数据。您可以参考以下链接

Excel 规范和限制 - 微软支持

此致敬意！

朱佑洛

如果这篇文章有帮助，那么请考虑接受它作为解决方案，以帮助其他成员更快地找到它。