Forum Discussion
Gateway set up with OneDrive
So, link copied from Excel Online is a little bit different:
https://myorg-my.sharepoint.com/:x:/r/personal/username/_layouts/15/Doc.aspx?sourcedoc=%7BD6325412-4802-4087-9279-1EDB9423E569%7D&file=DimCustomer%202.xlsx&action=default&mobileredirect=true&cid=53e19528-b115-4311-bd93-400edf596bb9
I then, tried to add new data source to the enterprise gateway I had installed:
data source type : Web
username: domain/username
password: domain password (windows)
authentication: windows
and received this 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
Activity ID: cac000c6-4ed3-4c7f-ad8a-1e2ccc57c89c
Request ID: 26bb7da1-0ca3-6984-92d9-27a5611d7f34
Cluster URI: https://wabi-us-north-central-redirect.analysis.windows.net
Status code: 400
Error Code: DMTS_PublishDatasourceToClusterErrorCode
Time: Tue Aug 06 2019 10:50:12 GMT+0200 (Central European Summer Time)
Version: 13.0.10315.184
bw-on-premise-gtw: Invalid connection credentials.
Underlying error code: -2147467259
Underlying error message: The credentials provided for the Web source are invalid. (Source at https://myorg-my.sharepoint.com/:x:/r/personal/username_layouts/15/Doc.aspx.)
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind: Web
Microsoft.Data.Mashup.CredentialError.DataSourcePath: https://myorg-my.sharepoint.com/:x:/r/personal/username/_layouts/15/Doc.aspx?sourcedoc=%7BD6325412-4802-4087-9279-1EDB9423E569%7D&file=DimCustomer%202.xlsx&action=default&mobileredirect=true&cid=53e19528-b115-4311-bd93-400edf596bb9
Microsoft.Data.Mashup.CredentialError.Reason: AccessForbidden
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"Web","path":"https://myorg-my.sharepoint.com/:x:/r/personal/username/_layouts/15/Doc.aspx?sourcedoc=%7BD6325412-4802-4087-9279-1EDB9423E569%7D\u0026file=DimCustomer%202.xlsx\u0026action=default\u0026mobileredirect=true\u0026cid=53e19528-b115-4311-bd93-400edf596bb9"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: AccessForbidden
Troubleshoot connection problems
New data source
https://myorg-my.sharepoint.com/:x:/r/personal/username/_layouts/15/Doc.aspx?sourcedoc=%7BD6325412-4802-4087-9279-1EDB9423E569%7D&file=DimCustomer%202.xlsx&action=default&mobileredirect=true&cid=53e19528-b115-4311-bd93-400edf596bb9
mydomain\username
•••••••The same happens when previous link was used.
Has any one succeed with setting up OneDrive data source for a gateway?
Maybe this was a typo in your comment, but it's domain\username not domain/username and that does make a difference. Try that and post your results.
It says your creds are incorrect, also make sure the id and password are correct. I assume that part is correct as that's obvious in the error.
ya, that was a typo. Still have this error.
No idea where the root cause is. Double checked the account name in Active Directory.
Is that can be caused by PingID normally use as additional security when signing in to intenal services?