Is there a way to bring Excel files in Sharepoint O365 into Qlik SaaS?
I can see a lot of metadata using the native connector but I am unable to get Excel file loaded in
This is something I spent some time trying to get working, and got tantalisingly close, but in the end discovered that it is not possible to do this.
It works fine in Qlik Web Connectors on premise, and the Cloud connectors work in a similar way, but the final part of the puzzle (the GetFile method) is missing.
I raised this with @chrisbrain at Qlik, and he agreed that it is a missing piece of functionality that needs to be added.
As for ETA on when it might appear, that is a different question.
Hopefully it will appear soon, as I know a lot of people who are wanting to do this.
I've just heard from @johngouws, over on the thread below, that a OneDrive connector has recently appeared. Hopefully they are looking at the full Microsoft stack and SharePoint will appear soon.
I found a work around which may be workable for some. You can convert your Excel file into a Sharepoint list. The ListItemsFromID function is available to load the List into Qlik Sense SaaS.
Unless I'm missing something, this is the same as has been available for a long while, allowing users to search Sharepoint and download lists.
The part that is missing is the final step, which is to load from a file which is situated on the SharePoint server. Talking to @chrisbrain on another thread, my understanding was that at some point a new connector would appear on the left hand list to surface file repositories in SharePoint as a file storage provider in Sense Cloud.
Hopefully I have missed something and this ability is now there.
Nope, probably me - I haven't tested it out, someone else asked about a sharepoint connector, and I missed the piece about loading an excel file. I'll ask internally ..
There is no Web Storage Provider connector for Sharepoint, which prohibits direct file access in Sharepoint. This is being worked on, but there is no ETA to be shared at this moment.
A possible workaround could be to use the OneDrive connector, as OneDrive utilizes same APIs as Sharepoint.