Data Pipeline reading from Sharepoint List

Hi schneiw,

Thank you for reaching out to the Fabric Community. I’m happy to assist you with your query.

• Based on your description, you are encountering this error while reading data from a SharePoint Online List using the connector. Could you please confirm whether you are implementing this in an Azure Data Factory (ADF) pipeline or a Fabric pipeline?
• If you are using a Fabric pipeline, this scenario typically works without issues. I recommend performing the validation steps outlined below. Please let us know if you continue to face any challenges.

1) Craete pipeline and open the below option to copy activity.

2) After adding copy data activity  then click source and broswe for the source.

3) Now select the relevant sharepoint source from the options listed.

4) It will open the below prompt and ask to login with your account. Do, so and connection will be craeted.

E.g Site URL: https://orgname-my.sharepoint.com/personal/[email protected]     

5) After the successfull connection you can perform copy activity task on the file you want.

If you find this response helpful, kindly consider marking it as the accepted solution and giving it a kudos. This helps others facing similar issues and is greatly appreciated.