Reload data from sharepoint file through QMC, failed with error: access is denied. Manual reload from qvw works fine
Hi,
We are using QlikView 11 SR12 SBE.
I have one QlikView extract that reads from sharepoint online 365 folder. The type of files that we are reading is .txt.
Below is the script that I am using to reload from the sharepoint folder. It works fine when I manually reload from the desktop qvw in the server.
LET vPath = '\\company.sharepoint.com@SSL\DavWWWRoot\sites\Projects\BIData\Shared Documents\UAT';
SysRecordCount:
LOAD *
FROM
[$(vPath)\Sys_Record_Count_*.txt]
(txt, unicode, embedded labels, delimiter is '|', msq);
However when reload via QMC schedule task I get the error:
Error: Cannot open file '\\company.sharepoint.com@SSL\DavWWWRoot\sites\Projects\BIData\Shared Documents\UAT\Sys_Record_Count_*.txt' Access Denied. Before opening files in this location, you must first add the web site to your trusted sites list, browse to the web site, and select the option to login automatically.
The user that I used to run the qmc task is the same as the user login to server as well as the login to sharepoint.
I have tried various solution found in community eg, install web client, check automatic sign into sharepoint 365, and add the site as trusted site but still not able to reload via schedule task.
