Reporting Services 2016 to SharePoint 2016 XML with CSOM?

Copper Contributor

I have Reporting Services 2016 connecting to SharePoint 2016 onPrem.  I'm trying to create a report with distinct values from a list column (in SP2016).  Standard methods in Report Services don't allow a distinct, so searching the internet lead me to use and XML option.


This link lead me to using XML, but I cannot successfully connect to the SharePoint list.  It cannot find the list or invalid format error.


I also read that this soap method was being depricated in favor of CSOM, so this link lead me to another method.


When I enter the XML data and test, I get "DTD is prohibited in the XML document". 


Can you help me resolve this issue?


0 Replies