idea SharePoint Connector August 2022 - read in multiple files (QlikSense) in Suggest an Idea

SharePoint Connector August 2022 - read in multiple files (QlikSense)

laura_gmp — Fri, 24 Mar 2023 09:52:43 GMT

Using the new 365 connector (Version August 2022) I am able to load files individually. But reading multiple files using the Sharepoint Connector is not supported. According to Qlik Support "Reading Multiple files directly seems to be product limitation". This basic missing functionality, is making it impossible to use the connector!

The best case would be to make the function native and work similar to folder connections.

There is a open Community article which describes the Problem in Detail: https://community.qlik.com/t5/Connectivity-Data-Prep/SharePoint-Connector-August-2022-read-in-multiple-files/td-p/2030265

Following error occurs "badFileSize Not found", when i use this FROM Statement:

FROM [lib://Sharepoint/DemoData/Data_*.xls] (biff, embedded labels, table is Data$);

To use the ListFiles to fetch all files in a folder and to loop through fails. The generation of the file list fails and therefore no lines are loaded.

EDIT 2023-03-24: Using the SharePoint Metadata Connector we can load from multiple files!

Re: SharePoint Connector August 2022 - read in multiple files (QlikSense)

josua_treasureraiser — Tue, 07 Mar 2023 16:32:38 GMT

A native function to read in multiple files using the Sharepoint Connector (similar to folder connections) would be great! Good idea Laura_gmp!

Re: SharePoint Connector August 2022 - read in multiple files (QlikSense)

AlexOmetis — Wed, 08 Mar 2023 12:14:29 GMT

If ListFiles in the SharePoint Metadata Connector is returning no rows then you might need to check the parameters you're passing it - I've had issues with getting the right site / subsite settings in there occasionally.

Re: SharePoint Connector August 2022 - read in multiple files (QlikSense)

laura_gmp — Fri, 24 Mar 2023 09:53:32 GMT

Thank you very much for your help, @AlexOmetis! I was missing the SharePoint Metadata Connector.

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 16:28:41 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: SharePoint Connector August 2022 - read in multiple files (QlikSense) - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 16:28:43 GMT