cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jenner2019
Frequent Visitor

Power BI Export (Header Quirks)

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. 

 

 

2 REPLIES 2
Community Support
Community Support

Re: Power BI Export (Header Quirks)

Hi @jenner2019 ,

 

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.

export.PNG

 

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.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
jenner2019
Frequent Visitor

Re: Power BI Export (Header Quirks)

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!

 

 

 

 

 

 

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

Top Solution Authors
Top Kudoed Authors