Forum Discussion
Extarct data from Sharepoint Online List using Azure Data Factory
thiru1981 One possible reason for this issue could be that the SharePoint list you are trying to extract data from is empty. If true, you will not see any data when you map the schema. You can verify if the list is empty by navigating to the list in SharePoint Online and checking if there are any items in the list.
If the list is not empty and you are still unable to see any data when you map the schema, there could be an issue with the configuration of your dataset. You may want to double-check that you have selected the correct site and list when configuring the dataset.
Let me know if this works for you. @ me in replies, or I'll lose your thread!!!
Note:
If my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!
BabatundeDallas thanks for your response. Yes, i have re verified LS and DS configuration. everything looks correct and also site and list all are valid and i have the data in the list.
- praveenthumatiAug 02, 2024Copper Contributor
Hi thiru1981 BabatundeDallas ,
Could you please confirm whether this pattern is working or not ?
I am also facing same issue linked service test connection is good.
pipeline finishes good and even displays all lists from SharePoint list dataset. But data preview shows blank and pipeline runs successfully but no data extracting.
if you resolved the issue please share the thought's
Thanks
Praveen