Forum Discussion
Gateway set up with OneDrive
HI v-xicai
"For your question1 , question2 and question3, to connect to the files located in OneDrive for Business , you need to use Web connector, pay attention to steps detail: Use OneDrive for Business links in Power BI Desktop."
I am trying the above and failing.
When select open in Excel my window look like this...
When click on "Copy path" my link is copied in the format:
C:\Users\aaaaaaa.bbbbbb\Downloads\DimCustomer 2.xlsx
Which is not the link to OneDrive but to a local copy.
I tried the "Copy link" too..
and the format of this is:
Is this a correct one?
Open in Excel online probably gives you the correct link as that's a public one which is not specified in the blog.
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.