Power BI Export (Header Quirks)

[Anonymous]

Hi Experts,

I am just curious what is happening here.

I wanted to maintain consistency when exporting the visual into different file formats.

I noticed my header changed when I exported the same visual into excel and csv. See screenshot below:

How do I keep the header names (Year vs Reporting Period - Year for example) consistency here? Help please!

Visual exported as xls and opened in Excel         versus             Visual exported as csv openend in Excel. 

[Anonymous]

Hi thanks for your reply.

I am using the same version of Excel (2016) and of Power BI desktop  Version: 2.76.5678.782 64-bit (December 2019).

I'm afraid I'm unable to share the dataset as it contains confidential information.

Tho I am open for suggestions or workarounds.

Regards and Thanks!

[v-frfei-msft]

Hi @Anonymous ,

Based on my test using Power bi desktop version : 2.76.5678.782 64-bit (December 2019). I canot reproduce your issue here. And I'm using Excel 2016.

Could you please update your Power bi desktop and check agian? Or you can share your sample data to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.