question

JuliusPistorius-9074 avatar image
0 Votes"
JuliusPistorius-9074 asked saldana-msft edited

SharePointOnline connector in Azure Synapse unable to connect to SharePoint Projects Online site

Issues connecting to SharePoint Project Online from Azure Synapse. We created a Service Principal as per https://docs.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list . Manage to view list items under the PWA site(https://{company}.sharepoint.com/sites/pwa), the moment we try to view the list items under https://{company}.sharepoint.com/sites/pwa/_api/Projectdata we run out of luck. Tried using SharePointOnlineList, Odata & Rest all pointing to same issue not authenticating.

fasttrack-azure
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@JuliusPistorius-9074,
Project related issues are not supported on Q&A, you should ask in Project community: https://techcommunity.microsoft.com/t5/project/bd-p/Project

1 Vote 1 ·

Hi @JuliusPistorius-9074
I am not a project online expert but I believe this is because the pwa api does not use the app only permission model which that document refers to. It needs to be accessed in the context of a user not an app principal. Adding SharePoint online tag to see if we can get further clarification.

0 Votes 0 ·

0 Answers