Forum Discussion
Data loading from excel in SharePoint site is taking more time
Sorting Rows is the killer step and we should try to avoid it as much as possible. Also using sharepoint folder connector is slower than accessing a single file on sharepoint directly.
Since this is a case of a single file only and I presume finding it is not rule based like all files created today / all files starting with alphabet A, the best bet would be to feed the path of file into PQ rather than feeding the folder path and then trying to locate the file.
Open Excel file in Sharepoint - File - Info - Copy path: This would give you the path which you need to feed into PQ. In PQ, you will need to use Get Data - From other sources - From Web
Let me know whether this is feasible for you or not. If not, I would like to know the logic which you are utilizing to locate the file then we can start thinking about how to avoid sorting.
Sorting Rows is the killer step and we should try to avoid it as much as possible. Also using sharepoint folder connector is slower than accessing a single file on sharepoint directly.
Since this is a case of a single file only and I presume finding it is not rule based like all files created today / all files starting with alphabet A, the best bet would be to feed the path of file into PQ rather than feeding the folder path and then trying to locate the file.
Open Excel file in Sharepoint - File - Info - Copy path: This would give you the path which you need to feed into PQ. In PQ, you will need to use Get Data - From other sources - From Web
Let me know whether this is feasible for you or not. If not, I would like to know the logic which you are utilizing to locate the file then we can start thinking about how to avoid sorting.