While exporting summary data for Line and Stacked Column chart , the exported header text has issue.

[bhavsarravi]

Using Line and Stacked Column chart , the exported summary data from embedding report has naming issue for header text.

It is particularly for the Line Values field text.

Steps to reproduce the issue:

1. Create a report, having visual using Line and Stacked Column chart. Create this chart having Line Values field and rename it with some text, other than field name.
2. Publish the report to Power BI service.
3. Open report in Power Bi service.
4. Export Summarized data from the Line and Stacked Column chart.
5. Exported excel report header text for Line Values column will be miss-matched.

Note: I have also tested this issue in Sample Application and Power BI service, where it is reproducable.

Please assist with this issue as soon as possible.

[bhavsarravi · Accepted solution]

Thank you. I was able to resolve this issue by deleting the Line value field and recreating it the same.

[v-yuezhe-msft]

@bhavsarravi,

Yes. I checked the columns in exported Excel and compare them to Power BI Service.

Regards,
Lydia

[bhavsarravi]

Did you checked for Export to Excel?

[v-yuezhe-msft]

@bhavsarravi,

Do you use Power  BI Desktop October release(2.63.3272.40461)? I repeat your steps in my Power BI Report and export data to Excel from the  Line and Stacked Column chart, the header name of Line matched that in Power BI Service.

Could you please share a PBIX file containing dummy data which I can reproduce?

Regards,
Lydia