Load multiple files from Sharepoint folder in Qlik Sense

[vkal12]

Hi everyone,

I have a question regarding the Qlik Office 365 Sharepoint connector. I have already created a data connection that links to my sharepoint folder from which I would like to load multiple excel files. 

First approach

Using * behind the data connection link does not work as I do get the error message: badFileSize Not Found

Second approach

I had a look through previous questions within the forum and tried it with the solution from the following article: https://community.qlik.com/t5/App-Development/Load-Multiple-Excel-Files-from-SharePoint-via-Web-Conn...

Unfortunately, when doing this I get another error message: badFileSize 

I thought this might be related to the URL that is used in this code. I've copied and pasted this link into my browser and there I get the error message: "Error Code 1. You should white list your IP address (XXXX) in 'Settings -> My Settings -> Allowed IP Adresses'.

After putting my IP adress on the white list, the link is still not working. 

I hope someone can help me to find a solution to this problem. 

Thank you very much in advance!

Kind regards,
Vanessa