How to have the source from the file in my local PC?

[tan_thiamhuat]

I am stuck with that Data gateway and could not proceed. Please help.

[v-saisrao-msft]

Hi @tan_thiamhuat,

We haven’t heard back from you in a while regarding your issue. let us know if your issue has been resolved or if you still require support.

Thank you.

[v-saisrao-msft]

Hi @tan_thiamhuat,

Have you had a chance to review the solution we shared by @NandanHegde ? If the issue persists, feel free to reply so we can help further.

Thank you.

[NandanHegde]

you need to set up an On Premises data gateway on the server hosting the file :

https://learn.microsoft.com/en-us/fabric/data-factory/how-to-access-on-premises-data

Post that while creating the connection, you can have the gateway drop down

[tan_thiamhuat]

I get the whoami to get the username for the domain\alias and I always got the credentials issue.

[v-saisrao-msft]

Hi @tan_thiamhuat,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

Thank you.

[v-saisrao-msft · Accepted solution]

Hi @tan_thiamhuat,

Please make sure you are entering your credentials in the correct format. For Microsoft Entra accounts,
user@domain.com

Check that your password is accurate and that your account is not expired or locked.

If you continue to experience issues, try installing the gateway on a different machine to eliminate possible local configuration or permission problems.

Thank you.

[tan_thiamhuat]

if file is on local PC, it cannot work?

[NandanHegde]

yes, you need to install the On prem data gateway on your local PC.

it would work

[tan_thiamhuat]

[v-saisrao-msft]

Hi @tan_thiamhuat,

Please uninstall the current gateway from your system, then clear the temporary files by deleting everything in the temp folder. Once that's done, download and install the latest version of the on-premises data gateway from the official Microsoft link.

Install an on-premises data gateway | Microsoft Learn

Solved: On premises Data gateway installation failed (stan... - Microsoft Fabric Community

Thank you.