Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I was able to extract data in XML format from the Sharepoint list when i am building the app in desktop version.
However, when i try to load the data from the same source on the Enterprise version, it says it cannot find the resource.
Please kindly advise.
thanks!
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.
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.
Hmm... exactly my thoughts. I was thinking if it is access issue. I shall bring this to my Sharepoint Administrator and see if we can work something out. Thanks for your input!
Cheers!
Hi Yee
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?
Kind regards,
Ozzie
Hi Ozzie,
You can see the link below to find out how to format the URL of the SP list as XML.
Getting XML Data From a SharePoint List – The Easy Way | Kirk Evans Blog
Then just go on to Data load Editor and add the URL under a new web file connection.
Cheers,
Guohao
Thanks kindly Guohao. Once the site is back up, I'll be sure to check this out.
Take care,
Ozzie
Hi Ozzie,
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.
Cheers,
Guohao
Thanks kindly for coming back to me.