This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 40%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
I have followed the guideline to import a sharepoint list using ADF:
I have created the Linked service. When I need to define the source in the pipeline, then when selecting the list, then no data is shown in the PreviewData. I can select a column which is also shown and see the data. I do not know what it is that I have done wrong, is there some setting on the list that needs to be specified.
I found the mistake. I had replaced the address in the Scope="..." with the direct reference to the sharepoint site. It should be as specified as below.
<AppPermissionRequests AllowAppOnlyPolicy="true">
<AppPermissionRequest Scope="http://sharepoint/content/sitecollection/web" Right="Read"/>
</AppPermissionRequests>
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Hello @Jan Boldt ,
Glad to know that you were able to find the actual root cause and appreciate much for sharing your findings with us here as it can be helpful for others who read this thread.
Thank you and have a good day!
Hello @Jan Boldt ,
Thanks for the question and using MS Q&A platform.
I tried to reproduce the issue on my end but no luck. I was able to see the data if I do a $select=* query on the selected List
Below is my dataset configuration, please make sure to select the List name in your dataset settings and try to do a preview data from the data set and then try to use the query in Copy Data activity source settings. If you are able to see the data from dataset preview tab then you should be able to see the data using Query under Copy Activity Source preview section.
If you still notice this issue, to work around, I would suggest to select the Table option instead of Query under Copy activity Source settings as you are trying to view the whole list data. If you want to filter specific data related to your list then use Query option.
Hope this will help. Please let us know if any further queries.
------------------------------
or upvote 
button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
I even tried to remove the complete query and did a preview and was able to view the data.
I would suggest to preview the data from your dataset and check if you can view from there.
Thank you for your reply. I have tried all possible ways (table and query) of extracting the data without luck. What is included in the "GetBearerToke" and would you have a link to a guide on how to set it up. I cannot see that as included in the guide I have used:
Could you provide a link to the guide you are using.
I am not getting any data when I preview the dataset of the sharepoint list, but when I choose one of the columns which is available, then data is shown.
The picture above shows that there is no data in the list.
The picture above shows that there is data in one of the columns.
The picture above shows the columns in the list.