Connectivity between Office 365 SharePoint and Qlik Sense

[balajibc64]

Hi, I'm using Qlik Sense May 2024 Version. I need to access the Office 365 SharePoint from Qlik Sense. 

Kindly suggest how to create connections, what could be the Base URL and Prompt/Consent level etc. 

[KalmerKaljuste-BeTerna]

No worries. Please Like and mark the question as solved 🙂
Have a nice day!

[balajibc64]

Hi @KalmerKaljuste-BeTerna My connection got successful. But after that when I tried to access the files. 

I'm getting the below message. 

" An error occurred

The remote server returned an error: (403) Forbidden" 

Please suggest. 

[KalmerKaljuste-BeTerna]

Did you also try in Step 5 to leave everything "un-selected"?
5) You might want to tick the "Automatically detect settings" or use automatic configuration script.




















If you still get an error when everything is unselected then there's probably a permission error on Sharepoint 365 side. Make sure that the user has enough priviledges to access the side (in azure)+
even though the service user has all the priviledges in SharePoint (with azure), you might need to also apply to the service account or user a 365 tenant to access and read/write the files.

[balajibc64]

Hi @KalmerKaljuste-BeTerna Thanks. Issue is I didn't give the SubSite path in the Connection. Now Its working fine. 

[diegozecchini]

Thanks for sharing it!