Alignment varies in Power BI service and exported excel

[Krishnapriya]

Hi Team,

I have created a table data in power bi. When i try to export it, the alignment changed in the excel. Is there any way to get the same alignment in exported sheet? please share your inputs.

Same data:

 

Here the Cury_price, cury_ext, aut_ext,receipt_no are in right alignment but in excel it is in left.

Thanks in Advance!

[ibarrau · Accepted solution]

Hi. I'm sorry but I don't think you can make the aligment keep from Power Bi to excel. They are completely different tools with totally different format applications.

There might be something to play around with aligment considering data types, because excel might align some values depending on the data types, but that's not for sure.

I hope that helps,

[v-heq-msft · Accepted solution]

Hi  @Krishnapriya ,
I’d like to acknowledge the valuable input provided by the @ibarrau   .  His initial ideas were instrumental in guiding my approach. 
When exporting to Excel, some formatting functions may not be directly translated due to the limitations of Excel. If you can, you can try to make changes to the data display in excel. If it doesn't involve maintenance of your data, you can use the export to PDF option, which will keep your data styled.
Export reports to PDF - Power BI | Microsoft Learn

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[ibarrau · Accepted solution]

Hi. I'm sorry but I don't think you can make the aligment keep from Power Bi to excel. They are completely different tools with totally different format applications.

There might be something to play around with aligment considering data types, because excel might align some values depending on the data types, but that's not for sure.

I hope that helps,