"Something Went Wrong" error when connecting dataset to Gateway

[vincetaylor]

I am trying to connect a new dataset to a gateway. Its a SharePoint site for which I have only read only access. (could this be the problem)

I am authenticating using my ownSharePoint Credentials. When I click on the Users tab, the error message below appears

[vincetaylor]

I also just realized that I am able to add source which are based on SharePoint online (cloud version).

But when I try to add Data sources from SharePoint 2013, it fails when I click on the edit credentials button

Unable to connect: We encountered an error while trying to connect to . Details: "OAuth login through the On-premises data gateway was unsuccessful. Specific error details available below and in the gateway logs."Hide details
Activity ID: ab5fd07d-918c-4573-8710-b2e1f94545de
Request ID: 0aaba057-1258-7ad5-cff2-a399d5126293
Cluster URI: Status code: 400
Error Code: DM_GWPipeline_Client_OAuthTokenLoginFailedError

[v-kkf-msft]

Hi @vincetaylor ,

Because Sharepoint2013 is in a local environment, try the Microsoft Account option for authentication.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

[_sfrost]

@vincetaylor 

Having read only access to the source should be enough to set up the data source on gateway.

I see your source is SharePoint and looking at the details you have filled in, I assume it's cloud. In this scenario you do not need a gateway. So, you can directly edit the credentials and set up the refresh in dataset settings.

Did I answer your questions? Give a thumbs up and accept this post as solution!

[vincetaylor]

Hi @_sfrost 
When I go to Dataset--> Settings,

The Dataset Credentials option is greyed out
The scheduled refresh option is also greyed out

I have added an image above

[aj1973]

Hi @vincetaylor 

SharePoint is in cloud therefore no need for a Gateway and the refresh is hourly...you just need to know how get data from SharePoint then build your reports on top of it.

[vincetaylor]

This is SharePoint 2013 which is on premise not Cloud