Forum Discussion

diegomengue's avatar
diegomengue
Frequent Visitor
5 years ago

Gateway won't access Network Folder

I'm using a excel file located on \\192.168.0.205\publica\notas_de_devolução_01_02_2021.xlsx. to build my data model. It works fine on PowerBi Desktop, but when I publish it and try to refresh, the gateway won't work. It says my credentials are invalid, but I'm 100% sure they are right.
Do I have to change the Gateway service account?

My gateway is located on a Virtual Machine IP 192.168.0.230, and the file-server is located on 192.168.0.205. I have different user names and passwords to access each VM.

 

Não é possível conectar: Encontramos um erro ao tentar conectar a . Detalhes: 

ID da atividade:f3700cc1-5731-404f-8e4e-fca0bb849084
Solicitar ID:d318b3dd-5c70-d1e9-f319-9b290c3edc35
Cluster URI:https://wabi-brazil-south-b-primary-redirect.analysis.windows.net/
Código de status:400
Código de Erro:DMTS_UpdateClusterDatasourceCredentialsErrorCode
Hora:Tue Feb 16 2021 10:31:53 GMT-0300 (Horário Padrão de Brasília)
Versão do serviço:13.0.15383.18
Versão do Cliente:2102.2.04869-train
Frutana Alimentos:Credenciais de conexão inválidas.
Código de erro subjacente:-2147467259
Mensagem de erro subjacente:As credenciais fornecidas para a fonte File são inválidas. (Fonte em \\192.168.0.205\publica\notas_de_devolução_01_02_2021.xlsx.)
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind:File
Microsoft.Data.Mashup.CredentialError.DataSourcePath:\\192.168.0.205\Publica\NOTAS_DE_DEVOLUÇÃO_01_02_2021.xlsx
Microsoft.Data.Mashup.CredentialError.Reason:AccessUnauthorized
Microsoft.Data.Mashup.MashupSecurityException.DataSources:[{"kind":"File","path":"\\\\192.168.0.205\\Publica\\NOTAS_DE_DEVOLUÇÃO_01_02_2021.xlsx"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason:AccessUnauthorized

2 Replies

  • Hi diegomengue ,

     

    The gateway is outside of your network and has to use a FQDN to get to any files.  It has no idea what that internal 193.... IP address is.  You have to use something like \\servername\folder\file  structure.  When you set up the gateway, you can use the "test connection" to confirm that it is working.

    • diegomengue's avatar
      diegomengue
      Frequent Visitor

      But I can access the file at \\192.168.0.205\publica\notas_de_devolução_01_02_2021.xlsx when I'm using the gateway VM. I don't understand why the gateway doesn't work.