On-premise data gateway not available for file names defined within another file

[vsagan]

We automated the creation of a csv file which contains the file (full path) of multiple files to read.  For example,

Folder,FileName

\\someNetwork\someFolder\,aFile.csv

\\someNetwork\someFolder\,aFile2.csv

I then had PowerBI read this file, and then added a custom column. use the Csv.Document(File.Contents()) command to read these files.

Specificaly, 

= Table.AddColumn(#"Changed Type", "Data", each Csv.Document(File.Contents([Folder] & [FileName])))

This worked fine in desktop.

The folder \\someNetwork\someFolder is a data source for our gateway.

Unfortunately, when publishing this desktop file to the service, the gateway complains and says the data sources are not supported.

[v-jiascu-msft]

Hi @vsagan,

Please vote on this idea: make-functions-refreshable-when-the-data-source-is. Since your files are from the same folder, why not use the folder connector directly?

Best Regards!

Dale

[vsagan]

Hi Dale,

Thanks for the suggestion.

Unfortunately, that is not appropriate for our use case.  The example above is a simplified version of our use case and your workaround is not appropriate for our actual case.

This looks like a bug and should be fixed.  The product does not appear to be working as described in the documentation.  All data sources are added to the gateway.  The error message is incorrect.