Forum Discussion

thiru1981

Copper Contributor

Jan 21, 2024

Extarct data from Sharepoint Online List using Azure Data Factory

Hello, I am trying to extarct the data from sharepoint online list.. but it gives empty file. I have followed the setup based on the below link. https://learn.microsoft.com/en-us/azure/data-fact...

BabatundeDallas

Brass Contributor

Jan 24, 2024

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 this post helps, please consider Accepting it as the solution to help others find it more quickly. OR
If my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Best Regards,

Dallas.

thiru1981

Copper Contributor

Jan 25, 2024

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.

praveenthumati
Copper Contributor
Aug 02, 2024
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