Invalid Credentials Dataflow + On-premise data gateway

[davidotoosakyi]

Hello, community

I have been trying to set up a connection whereby I can upload files from my local drive to Power BI Dataflows using an on-premise data gateway. I have installed the gateway successfully and have it running online. However, it has been a challenge uploading my file (an Excel file) to Dataflow, which keeps complaining about credentials.

I created a connection name, but Power BI Service is not accepting the custom username and password I provided. When I click on "Skip test connection", it automatically generates a login credential for the Windows authentication type. It seems these credentials have been encrypted, as I don't have access to them. I was expecting it to automatically populate whenever I select the connection name in the process of uploading my local files to DataFlow; however, this is not the case, and whenever I provide a username and password of my own, it keeps returning an invalid connection.

I have tried solutions provided here, here, and here but all to no avail.

Kindly provide help on how I can scale through this phase. Thanks

[ibarrau · Accepted solution]

Hi. Credentials for local files can be tricky. The tip here is that the user must use the Domain before the name. Like

User: DOMAIN\ibarrau

Pass: ******************

If you are not under a company domain, then use the PC name (like "DESKTOP-MSFS35")

You can read more about credentials in this discussion: https://community.fabric.microsoft.com/t5/Service/Unable-to-connect-to-gateway-to-datasource-given-c...

I hope that helps,

[davidotoosakyi]

Works perfectly.

I also tried using only the ''alias" and my username. It did work as well.

Thanks for your help.