Error de credenciales no validas en gateway local

[Cognisanalytics]

Hola comunidad,

Estoy intentando configurar una conexión desde Power BI Service a un archivo local (Excel) ubicado en mi cuenta personal de one drive.

Estoy usando el gateway en modo personal, instalado y conectado correctamente en mi PC, con mi usuario

Ese usuario tiene contraseña (uso esa misma para iniciar sesión en Windows) y accede al archivo sin problemas desde el explorador.

Sin embargo, al crear la conexión desde Power BI Service, recibo el error:

“No se puede crear la conexión: Credenciales de conexión no válidas”

Ya probé:

Confirmar usuario con whoami

Verificar que el archivo esté sincronizado localmente desde OneDrive

Reinstalar el gateway

Probar con otro archivo y otra ruta

Limpiar credenciales desde el Administrador de credenciales

¿A alguien le pasó algo similar o tiene idea de qué más probar?

Gracias de antemano por la ayuda

[v-lgarikapat · Accepted solution]

Hi @Cognisanalytics ,

Thanks for reaching out to the Microsoft fabric community forum.

@Akash_Varuna 

Thanks for your prompt response

In addition to @Akash_Varuna  troubleshooting steps below, here are a few more that may help you resolve the issue.

To fix the invalid connection credentials error when connecting Power BI Service to a local Excel file using the personal gateway, make sure you're using the correct Windows username format like DOMAIN\username, and re enter your credentials in Power BI Service under gateway settings. Try connecting to the folder instead of the file directly, and ensure your gateway is updated to the latest version. Avoid using network paths keep the file in a local or OneDrive-synced folder. Also, check that the gateway service account has proper permissions, and if issues continue, consider switching to the enterprise gateway(Standard Mode )for better control. 

For references

Solved: On premise Gateway local excel error - Microsoft Fabric Community

Solved: Getting invalid credentials error while creating g... - Microsoft Fabric Community

Troubleshoot gateways - Power BI | Microsoft Learn

If you're still facing challenges, feel free to let us know we’ll be glad to assist you further.

Looking forward to your response.

Best regards,
LakshmiNarayana.

[v-lgarikapat]

Hi @Cognisanalytics ,

I wanted to follow up and confirm whether you’ve had a chance to review the information we shared. If you have any questions or need further clarification, please don’t hesitate to reach out.

If you're still encountering any challenges, feel free to let us know  we’d be glad to assist you further.

Looking forward to your response.

Best regards,
Lakshmi Narayana

[Cognisanalytics]

Hi!

Thank you for your recomendations! the gateway service account didnt have its proper permissions to access de file, it was that!!

Thank you very much for your help!

[v-lgarikapat]

Hi @Cognisanalytics ,

Thank you for the confirmation and for sharing the workaround. I really appreciate your support.

Best Regards,

Lakshmi Narayana

[Akash_Varuna]

Hi @Cognisanalytics It might be due to how the gateway interprets OneDrive paths. Ensure you're using the local synced file path. Confirm the gateway runs under the same user account with access. If the issue persists, try moving the file to a local folder outside OneDrive.