SharePoint List not showing in Azure Synapse Analytics

Gabe 1

I have been setting up SharePoint List and Pulling the data into Azure Synapse Analytics for Power BI report for long time through Linked Service.

This time set up a Linked Service. I can see the SharePoint List from Azure Synapse Analytics Studio but I do not see any data or columns.

What am I doing wrong that is preventing me from seeing the data?

I am using the same credentials. Please advice?

Gabe 1 Reputation point

2025-02-12T18:36:18.99+00:00

No preview data to show
Chandra Boorla 8,310 Reputation points Microsoft Vendor

2025-02-13T06:19:04.7866667+00:00

Hi @Gabe

Greetings & Welcome to Microsoft Q&A forum! Thanks for posting your query!

I understand that you're having trouble seeing data from your SharePoint List in Azure Synapse Analytics, even though you can see the list itself. Here are some troubleshooting steps you can take to resolve the issue:

Check Permissions - Ensure that the account you're using has the necessary permissions to access the SharePoint List. It should have at least "Read" permissions.

Review Linked Service Configuration - Double-check the configuration of your Linked Service in Azure Synapse Analytics. Make sure the SharePoint site URL is correct and that you're using the right authentication method.

Data Source Settings - Verify that the SharePoint List is properly set up as a data source. Sometimes, specific settings on the list can prevent data access.

Refresh Data - If you recently created or modified the SharePoint List, it might take some time for the changes to reflect in Azure Synapse. Try refreshing the data source or reconnecting.

Network Considerations - Ensure there are no network issues or firewall settings that could be blocking access to the SharePoint List.

Look for Error Messages - Check for any error messages or logs in Azure Synapse Analytics that might provide more context about the issue.

Please refer to the below MS Q&A threads addressing similar issue.

https://learn.microsoft.com/en-us/answers/questions/849691/the-sharepoint-list-is-empty-when-import-from-azur

https://learn.microsoft.com/en-us/answers/questions/755425/link-sharepoint-online-in-synapse

Please refer to the links provided below, as they might offer some insights that could help you address your question.

https://github.com/kasperulvedal/Azure-Data-Factory-Stuff/blob/main/Linked%20Services/Sharepoint/Setting%20up%20Sharepoint%20so%20Azure%20Data%20Factory%20can%20access%20it.md#setting-up-sharepoint-so-azure-data-factory-can-access-it

https://www.youtube.com/watch?v=FFfNu3cI-uw

Disclaimer: This response contains a reference to a third-party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

I hope this information helps. Please do let us know if you have any further queries.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Thank you.
Chandra Boorla 8,310 Reputation points Microsoft Vendor

2025-02-14T10:20:46.39+00:00

@Gabe

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

SharePoint List not showing in Azure Synapse Analytics

Your answer