PerformancePoint Services PowerPivot Data Sources Error

Written by Dan English

Thursday, 22 July 2010 21:35

So I was working on a PerformancePoint 2010 dashboard and making really good progress. I then ran had to add a new source into a PowerPivot (Excel 2010) file and the source was a SharePoint 2010 list. I went out to the SharePoint list and clicked on the Export as Data Feed option in the SharePoint Ribbon List options. When I pulled this atom feed into PowerPivot I ended up receiving an error message (even though the connection tested out okay) stating

“For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method”