Exporting Performance Point Data Throws Duplicate Headers Received Error

Version 1.0

Error

Recently I came across a situation where a user was trying to export a SharePoint Performance Point dashboard data to Excel and was getting the Duplicate Header Received error.

Duplicate headers received from server

ERR-RESPONSE_HEADERS_MULTIPLE_CONTENT_DISPOSITION

Duplicate Headers Received Error When Exporting PerfPoint.jpg

 

Details

I looked into the PerformancePoint dashboard and used the export to Excel option.

SPProd_PerfPoint_Report_Export_to_Excel_Duplicate_Header_Issue_02.png

 

I was able to export the data to excel and view it in there.

SPProd_PerfPoint_Report_Export_to_Excel_Duplicate_Header_Issue_03.png

 

Under one instance, when I used ‘Export to Excel’ option, the file download dialog box showed an extremely long file name with lots of special characters.

SPProd_PerfPoint_Report_Export_to_Excel_Duplicate_Header_Issue_01.png

 

Root Cause

It turns out to be the user was using the Chrome browser instead of Internet Explorer. The error is specific to Chrome as other browsers ignore the duplicate headers.

Enclosing the file names in ” ” or using underscore instead of spaces or comma (,) is one solution.

Read the following articles for little mode details on the issue.

a. Fix for Duplicate Headers Erro 349

b. Duplicate Headers received from Server

 

Keywords
  • PerformancePoint data export error
  • PerformancePoint data export error in Chrome
  • PerformancePoint Export to Excel does not work in Chrome
  • SharePoint PerformancePoint Dashboard Error
  • SharePoint PerformancePoint BI data export Error
  • SharePoint Duplicate Header Received error
  • SharePoint Duplicate Header error
  • SharePoint with Internet Explorer VS Chrome

Leave a Reply

Enter the CAPTCHA * Time limit is exhausted. Please reload CAPTCHA.