Cannot get QlikView/Qlik Sense to access SharePoint List Access is denied: the authentication has failed or has not been provided

[Sonja_Bauernfeind]

A Data Connection to SharePoint list in QlikView/Qlik Sense fails. When trying to connect, the user receives an error:

Access is denied: the authentication has failed or has not been provided

Resolution:

The authentication error when connecting to SharePoint is caused by the service account ID not being passed to the zone. We will need to modify settings to allow for UserID and Password to be passed.

In order for QlikView/Qlik Sense to be able to connect to a SharePoint list using a URL, a local policy setting must be used. To add this local policy, perform the following steps on the QV publisher server(s) / QS Central Node (&Proxy RIMSs).

1. From run enter gpedit.msc and press <enter>
2. Under Computer Configuration expand administrative templates
3. Expand Windows Components
4. Expand Internet Explorer
5. Expand Internet Control Panel
6. Highlight Security Page
7. Under Security Page you will see Site To Zone Assignment List
8. In the window on the right hand in the upper left corner you will see Edit policy setting. Click on what looks like a link. That will open up a window for the policy setting.
9. Make sure the Enable radio button is selected.
10. Click on the show button.
11. This will open up a show contents window
12. In the value name box key in domain you want to allow (SharePointsite).
13. In the value box key in a “1”. This will set the domain to local Intranet. This will allow any account on the server to connect to the domain via a URL.
14. Click Ok, then Click Ok again.
15. Close the Local Policy Editor

Related content:

How to load an Excel file from sharePoint to Qlik Using Qlik Web Connectors
Fetching data from files on SharePoint with Qlik Sense