topic Re: Load Sharepoint O365 Excel file in SaaS in Management & Governance

Load Sharepoint O365 Excel file in SaaS

avastani — Sat, 16 Nov 2024 01:57:22 GMT

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

Re: Load Sharepoint O365 Excel file in SaaS

stevedark — Thu, 09 Jul 2020 17:04:56 GMT

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.

Steve

Re: Load Sharepoint O365 Excel file in SaaS

illinileo — Wed, 22 Jul 2020 02:57:33 GMT

Totally agree that this is needed. This is a show stopper for me right now.

Re: Load Sharepoint O365 Excel file in SaaS

stevedark — Wed, 22 Jul 2020 06:59:30 GMT

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.

https://community.qlik.com/t5/Qlik-Sense-SaaS-Multi-Cloud/Qlik-Sense-Business-OneDrive-Connector/m-p/1729740

Re: Load Sharepoint O365 Excel file in SaaS

barnabyd — Fri, 11 Sep 2020 07:09:48 GMT

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.

Cheers,

Barnaby.

Re: Load Sharepoint O365 Excel file in SaaS

Julie_Main — Thu, 01 Oct 2020 08:50:47 GMT

Office 365 Sharepoint connector is now available through the script editor when you create a new connector 🙂

Re: Load Sharepoint O365 Excel file in SaaS

stevedark — Thu, 01 Oct 2020 19:40:41 GMT

Hi @Julie_Main

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.

Steve

Re: Load Sharepoint O365 Excel file in SaaS

Julie_Main — Fri, 02 Oct 2020 09:38:12 GMT

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 ..

Re: Load Sharepoint O365 Excel file in SaaS

stevedark — Fri, 02 Oct 2020 09:48:45 GMT

Thanks @Julie_Main , much appreciated. I've a number of other threads to update when this functionality does appear.

Re: Load Sharepoint O365 Excel file in SaaS

ToniKautto — Thu, 26 Nov 2020 04:00:16 GMT

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.

https://help.qlik.com/en-US/connectors/Subsystems/Web_Storage_Provider_Connectors_help/Content/Connectors_StorageProvider/Introduction/Web-Storage-Provider-Connectors-Introduction.htm

Re: Load Sharepoint O365 Excel file in SaaS

reanfadyl — Thu, 25 Mar 2021 21:21:09 GMT

Did anyone trying using the OneDrive connector to connect to Sharepoint?

Re: Load Sharepoint O365 Excel file in SaaS

ToniKautto — Wed, 05 May 2021 04:58:52 GMT

Some good news on this topic. Office 365 Sharepoint storage provider connector is now available. See help page for more details.

https://help.qlik.com/en-US/connectors/Subsystems/Web_Storage_Provider_Connectors_help/Content/Connectors_StorageProvider/Introduction/Web-Storage-Provider-Connectors-Introduction.htm

Re: Load Sharepoint O365 Excel file in SaaS

stevedark — Fri, 07 May 2021 13:04:10 GMT

I believe that the Web Storage Provider for Sharepoint is now available. Not had a chance to try it out yet, but even a rumour of it existing is a big step forward!

Steve