Connecting to SharePoint folder - Incredibly slow?

[PBInonpro]

SharePoint connection is incredibly slow, is this a known issue? (vs shared/local drives). 

And when selection 'column distribution' it is showing an error. 

[v-yadongf-msft · Accepted solution]

Hi @PBInonpro ,

Connecting to sharepoint folder works fine in my Desktop.

The slow connection may be related to data size of your sharepoint folder.

Column distribution also works fine:

If your data format is not in the expected format, you will get the error as below shown:

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.