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.