Unable to set up Excel file on internal path to Gateway Data Source

[Anonymous]

Hi Experts

I am unable to set up an excel as a data source on the Gateway either by using File  as Data Source and or putting that excel file into a folder.  Keep on getting error message unable to connect to datasource. 

I have full access to the file and the folder and internal drives where the excel file is sitting

Any work arounds?

[MFelix]

Hi @Anonymous ,

What gateway are you using: the standard one or the personal one? Where is the gateway installed and what is your user the one that is register in the gateway?

[Anonymous]

Hi M Felix - its an on prem gateways and the file is saved on internal directory

[MFelix]

Is the user you are using on the gateway the same one that is configured in the access to the dataset?

[Anonymous]

Yes, i can add all other dataset sources and connect - just this excel - playing up

[MFelix]

Does the excel has a password to proctet it?

[Anonymous]

No....this is where i am confused simple .xlsm file

[MFelix]

Hi  @Anonymous ,

This can be an error related with the fact that is a XLSM (macro enabled) file. To what I can see there are several erros when connecting to this type of file.

Can you connect to other XLSX files?