Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Qlik SAAS SharePoint connector 403 error when trying to select data in the preview

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Andreas_Giesbrecht

Qlik SAAS SharePoint connector 403 error when trying to select data in the preview

Last Update:

May 10, 2022 10:34:28 AM

Updated By:

Jamie_Gregory

Created date:

Apr 19, 2022 7:08:02 AM

You might encounter a 403 error when trying to select data from a new created SharePoint connection in Qlik Sense SAAS:

Andreas_Giesbrecht_1-1650376749922.png

This error might occur even though the creation of the connection was successfully tested and created for a specific SharePoint Site/ Subsite:

Andreas_Giesbrecht_0-1650376593517.png

Probably the root cause of this issue might be not enough user permissions on that specific SharePoint Site/ Subsite. For troubleshooting purposes please try to setup the Qlik SharePoint connection with a SharePoint admin user and try to reproduce the issue again, usually the error should not appear anymore.

 

Environment

  • Qlik Sense Cloud Services
  • Qlik SharePoint connector

 

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Comments
mjht
Creator
Creator

This is happening with Qlik Sense Enterprise on Windows  release Feb 2023 Patch 6.

The user can create a connection with the builtin sharepoint 365 connector and test it successfully.  When he tries to use it to select data, he gets a 403.

He is able to drill down via the Sharepoint Site ( not thru Qlik Sense) from the root down to the folder where his excel document resides and open the document without getting an error.  

He is able to create the connection in Qlik Sense and test the connection successfully.  

The error only shows when he tries to select data. 

This doesn't make sense since he can drill down from top level thru the path to his document when he is in Sharepoint 365.  

Can someone please explain where the permission issue exists?

Qlik Sense Enterprise on Windows , Qlik Sense Office 365 Sharepoint connection, permissions

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @mjht 

The Qlik SharePoint connector is based on the MS API, as such it is likely that the user does not have all the required permissions on a specific site to drill down using the API. We recommend reviewing the log files and contacting your SharePoint admin.

Should that not help you resolve the issue, please post in our forums, where our active community and our agents can help you further.

Example forum: Connectivity & Data Prep.

All the best,
Sonja 

Version history
Last update:
‎2022-05-10 01:34 PM
Updated by: