Forum Discussion
Advocate IVData 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.
Advocate IVThank you all, it appears it was just my URL in the connection that was not correct. I had reused the connection from the Copy Job, that sems to be a mistake, not sure why they are different, but the trick was to create the connection via the data pipeline UI to get the valid URL crqted correctly.