topic Oauth2 scope required for SharePoint lists? in Developer

Oauth2 scope required for SharePoint lists?

Anonymous — Tue, 01 Aug 2023 17:53:06 GMT

Hello,

We have a datasource that is of type "SharePointList".

According to the documentation https://learn.microsoft.com/en-us/rest/api/power-bi/gateways/update-datasource, we are updating the OAuth2 credentials with an access token. However we always get a 400 error code. We also do this with an Azure SQL datasource and this work fine for that datasource type.

The documentation says "Set the OAuth 2.0 token audience correctly, according to the data source type.".

Can you specify which scope is required by the datasource type "SharePointList" so we can retrieve an appropriate access token that can be used to connect?

We tried:

Thank you!

Re: Oauth2 scope required for SharePoint lists?

Anonymous — Thu, 03 Aug 2023 07:41:56 GMT

Hi @Anonymous ,

As far as I know, if your data source is SharePoint, I think you can select connection type as SharePoint directly when you configure data source for gateway in Power BI Service.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Oauth2 scope required for SharePoint lists?

Anonymous — Tue, 08 Aug 2023 13:44:04 GMT

Hello,

Thank you for your answer, but actually this was not my question as I was speaking about SharePoint Online (not on-premises) and using the APIs.

What is the scope required for getting an access token that we can set in the OAuth2 credentials of the SharePointList type datasource type ? Graph ? Others ?

Thank you.

Re: Oauth2 scope required for SharePoint lists?

Anonymous — Fri, 25 Aug 2023 08:56:43 GMT

Hello @Anonymous,

Can you check with your teams what is the scope required for getting an access token that we can set in the OAuth2 credentials for the SharePointList type datasource type ? Graph ? Others ?

Thank you!