Skip to main content
Microsoft Idea

Power BI

New

Optimize sharepoint folder connector for single file selection

Vote (1) Share
Pascal Bellerose's profile image

Pascal Bellerose on 19 Oct 2021 16:23:36

The Sharepoint Folder connector is way too slow when I have ot read a single file that is stored on Sharepoint.

I don't see why there wouldn't be an "Online Excel File" connector that would render as "Excel.Workbook(Web.Contents())".

Or at least, when using Sharepoint Folder connector and the user ends up selecting a single file, it should be rendered using the Web.Contents connector and get rid of the steps that scans the Sharepoint site for all files.



I endup using Excel.Workbook(Web.Contents()) to speedup the file reading part. Otherwise the query is very slow if the Sharepoint site contains thousands of files.