We have an established QlikView platform where many apps are reloaded and distributed via QMC pulling data from our data warehouse. QMC uses a service account to do this.
We have a new requirement to use SharePoint as a data source. We can open the SharePoint lists from the server in a browser, so all the firewall are open. But when we try and reload the app via QMC it fails. I think because this service account doesn't have permissions on SharePoint (and apparently it can't have).
Has anyone done this before: reloading SharePoint data into apps in QMC scheduled jobs?