Forum Discussion
Gateway Authentication Error
The enterprise gateway is usually installed on a Windows Server VM in your company's on-premise environment. It has no idea what you mean by "C:\". You should place your Excel files into a location that is accessible by the gateway. Ideally, place the Excel files into a SharePoint/OneDrive - then you don't even need a gateway.
Do not install the gateway on the same machine as the SQL server. That will not end well.
The enterprise gateway is usually installed on a Windows Server VM in your company's on-premise environment. It has no idea what you mean by "C:\". You should place your Excel files into a location that is accessible by the gateway. Ideally, place the Excel files into a SharePoint/OneDrive - then you don't even need a gateway.
Do not install the gateway on the same machine as the SQL server. That will not end well.
Yeah, that was it man.
Thank you for the help.
I uploaded the files on Google Drive and then, got the sharing link as editor and used it as the data source.
Thanks so much.
