How To Load Data From SharePoint File In SaaS

This is a known issue in SaaS and our product team is working on to get GetFiles function available. This has been discussed in https://community.qlik.com/t5/Qlik-Sense-SaaS-Multi-Cloud/Load-Sharepoint-O365-Excel-file-in-SaaS/td-p/1725885. 
 

Currently please try the work around which may be workable, which is to convert your Excel file into a Sharepoint list. The ListItemsFromID function is available to load the List into Qlik Sense SaaS.

Here are the information for creating a list in Sharepoint from Excel file.

https://www.kalmstrom.com/Tips/SharePoint-Online-Course/Import-Excel-Spreadsheet.htm

https://support.microsoft.com/en-us/office/create-a-list-based-on-a-spreadsheet-380cfeb5-6e14-438e-988a-c2b9bea574fa

https://support.microsoft.com/en-us/office/create-a-list-0d397414-d95f-41eb-addd-5e6eff41b083

https://sharepointmaven.com/create-custom-list-sharepoint/ https://support.microsoft.com/en-us/office/create-a-list-0d397414-d95f-41eb-addd-5e6eff41b083