Issues linking the on-premise gateway using data type "folder"

I have a desktop report that links to around 100 different excel files, all sitting in the same folder on a company drive.  I was not able to use the "Get Data - Folder" option because all of the exc...