You must ensure that the User Account that the server is running under has proper access to SharePoint and the SharePoint list that you want to retrieve data from.
On Desktop you are running as your personal account - but the server has been assigned to run under a Service Account of some sort. This Service Account must be set up with the proper access rights to SharePoint.
If you don't mind, how where you able to extract data in XML format from the Sharepoint list you used when building the app in Qlik Sense desktop version? I am using the desktop version.
What did the URL connecting you to the Sharepoint list look like and what Qlik connector and parameters did you use?
You can see the link below to find out how to format the URL of the SP list as XML.
Then just go on to Data load Editor and add the URL under a new web file connection.
Apologies for the late reply. Has been swarmed lately at work.
I experienced the same issue with linking to SharePoint from Enterprise server. The problem could be either of below:
1. Connection issues between the SP server and Qlik server
2. Permission issue - my SharePoint lists requires AD for access. When trying to connect to SP from the enterprise server, Qlik enterprise server is not able to access the list using my AD and thus, getting access denied
I haven't found a fix for this yet so I cannot pin point the root cause. My work about is to simply use Task Scheduler to run a Excel Marco that refreshes a SP-linked table and save it to a folder where the Qlik can pick up the data.
hope this helps.