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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.