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

mamdhooh — Tue, 07 Apr 2020 20:13:18 GMT

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 excel files are not setup the same way, different column names on most. So I had to use the "Get Data - Excel" on all. Here is an example of my "Advanced Editor" code

let
Source = Excel.Workbook(File.Contents("\\***********\********\Purchasing\IPL's\73-20-11 3244735.xlsx"), null, true),
Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],...........

I've published the report and set-up a "Data Source Type - Folder" pointing to the folder where all of these excel files are located. It says "Connection Successful". Yet, I can't link the gateway to that report and it appears it wants me to set up a gateway for each individual excel file.

I read this article posted by Chris Webb that seems to address the issue I'm having but I am not having any luck.

Any ideas other than creating a separate gateway for each excel file?

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

Greg_Deckler — Tue, 07 Apr 2020 20:28:15 GMT

Well, it is an older blog article, things may have changed, perhaps cwebb can indicate if it still works?

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

cwebb — Wed, 08 Apr 2020 16:21:53 GMT

Hmm, I've just taken a look and something has definitely changed. I'll find out what and report back.

Chris

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

mamdhooh — Mon, 13 Apr 2020 15:25:49 GMT

Thanks for your help.

topic Re: Issues linking the on-premise gateway using data type "folder" in Report Server

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

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

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

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