Invalid connection credentials while adding data sources

[Johnmatta]

Hi All,

I've installed and configured on-premise data gateway but when I try to adding data source (in this case an Excel file saved on my desktop) I get the below error details:

Unable to connect: We encountered an error while trying to connect to c:\users\johnmatta\desktop\book1.xlsx. 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:	6436b4ab-689e-7514-2ba6-5d86778a445c
Request ID:	f8dfb7d6-fe6d-a84a-7b64-6e15f044f282
Cluster URI:	https://wabi-australia-southeast-redirect.analysis.windows.net
Status code:	400
Error Code:	DMTS_PublishDatasourceToClusterErrorCode
Time:	Wed Jun 06 2018 23:45:53 GMT+1000 (AUS Eastern Standard Time)
Version:	13.0.5484.164

Gateway1:	Invalid connection credentials.
Underlying error code:	-2147467259
Underlying error message:	The credentials provided for the File source are invalid. (Source at c:\users\johnmatta\desktop\book1.xlsx.)
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind:	File
Microsoft.Data.Mashup.CredentialError.DataSourcePath:	c:\users\johnmatta\desktop\book1.xlsx
Microsoft.Data.Mashup.CredentialError.Reason:	AccessUnauthorized
Microsoft.Data.Mashup.MashupSecurityException.DataSources:	[{"kind":"File","path":"c:\\users\\johnmatta\\desktop\\book1.xlsx"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason:	AccessUnauthorized

[Anonymous · Accepted solution]

@Johnmatta,

Do you install gateway in the same machine with your Excel file? Please make sure you enter correct user name and password when adding Excel data source, you can follow the guide in the similar thread below.

https://community.powerbi.com/t5/Integrations-with-Files-and/Scheduled-refresh-for-excel-file-with-o...

Regards,
Lydia

[Johnmatta]

Thanks Lydia for your response.
Yes, I did install the gateway on the same machine that the Excel file is located.

I feel that the issue is in the username as the post you've attached refers to putting domain\username and my laptop is not on any domain.

[Johnmatta]

Hi Lydia,

I've found my domain\user and the datat source added successfully but when I tried to refresh the data I got the floowing message:

[Anonymous]

@Johnmatta,

Please post the data source setting(File->Options and settings->data source setting ) in Power BI Desktop and share a screenshot about the data source you added within your gateway. Please do mask sensitive data before you upload screenshots.

Regards,
Lydia

[Johnmatta]

Sorry Lydia, I figured it out now. The windows username was AzureAD\my user name and I had to choose the gateway under dataset settings...thanks so muck for your help.

[vladmoza]

Hi @Johnmatta ,

I am encountering the same exact issue at the moment, could you please guide me to how you found out the username and what steps you took to make it work?

Big thanks,

Vlad

[Johnmatta]

Hi @vladmoza ,

Please find the below steps:

1.  in Windows 10 go to >> Windows Settings >> Accounts
2.  on the left hand side click >> Other people
3. under "Adda work or school user" >> you'll see your username which starts with "AzureAD\yourname" and this is the username you need to use

hope that helps.

John

[Anonymous]

Hi. @Johnmatta @Anonymous . I am facing some problems. When I try to connect i get same credenctial problems:

DMTS_PublishDatasourceToClusterErrorCode

We could not register this data source for any gateway instances within this cluster

Cluster URI:       https:wabi-north-central-primary-redirect.analysis.windows.com

Could anyone help?Thanks.