403 permission issue when calling SharePoint EndPoint via HTTP Activity

Question

Hi Community,

I am using Data Factory to pull data from Excel files on SharePoint Site following with the guide from here: https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory.

After getting token, it always failed at authentication part.

Anyone can help to resolve it?

Answer 1

Hello @Simon Zhang ,

Thanks for the question and using MS Q&A platform.

Make sure you have meet the prerequisites as `Grant SharePoint Online site permission to your registered application.

Microsoft Azure Data Factory guide on setting up the connection to the SharePoint site and look at the Prerequisite: Copy data from SharePoint Online List by using Azure Data Factory or Azure Synapse Analytics

For more details, refer to How To Fix Azure Data Factory 403 Forbidden SharePoint Site.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on 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
• Want a reminder to come back and check responses? Here is how to subscribe to a junotification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is jhow you can be part of Q&A Volunteer Moderators

Answer 2

It's a configuration issue. I changed lots of configures and the issue is resolved but I don't know which one is causing the issue.