Hello, my team has a gateway setup that refreshes a variety of datasources (mostly sql serverbased). I've added more than a few data sources by specifying the server, database, entering credentials and so on. The problem I have now is when I attempt to enter a sharepoint list as a new source, I'm receiving a credential error (see below).
I've reviewed what I could between these asks, but they don't seem quite relevant:
My end goal is to have the sharepoint site accesible by our gateway(which lives on our server) so that we don't have to have our personal credentials needed when the scheduled refresh kicks off. Right now, the report owner is using her personal credential set for the sharepoint site and the gateway credentials for the other sources (all sql).
While creating the source, I'm using -
Type: Sharepoint, Sharepoint URL: ....., Authentication Method: Windows, Username/Password have been validated to have ownership level access, Privacy Level: Organizational.
Here's the error:
Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details
Mon Jul 09 2018 15:57:17 GMT-0700 (Pacific Daylight Time)
Invalid connection credentials.
Underlying error code:
Underlying error message:
The credentials provided for the SharePoint source are invalid. (Source at https://microsoft.sharepoint.com/teams/IFMWEB/Lists/hierarchy/Building%20List.aspx.)
We are PRO and have been using it for over a year but got hit with the same random error. Just found out our issue appears to be part of a widespread issue that MSFT is aware of.