Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
diegomengue
Frequent Visitor

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 2
collinq
Super User
Super User

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors