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.
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
|
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.