Enterprise Gateway greyed out

[Anonymous]

Hello -

We have an enterprise gateway connected to on prem server locations and successfully using it on certain data sets and sources. However, on additional datasets, the option doesn't appear. All the files and folder locations have been added to the Gateway Manager settings. But when you go to the dataset settings, the Enterprise Gateway isn't available. 

Is there an error report or some way to determine why the Enterprise Gateway isn't available for certain datasets even though all the sources have been added to the gateway settings menu? 

[nineruteAE]

For anyone having trouble with this like I was - your file/folder name on your enterprise gateway data source must match exactly with the data source in the report file.

I had a bunch of excel files in a folder and had "Use an enterprise gateway" greyed out. As soon as I made a new gateway with the exact name of the data source I was using in the report - Boom - it came up as an option to use the gateway

[Anonymous]

Does "must match exactly" mean it must match case too?

[mahimabedi]

Hi,

I am facing the same issue. Although the documentation states that the enterprise gateway should work for import data, when I try to set up a refresh it directs me to use a personal gateway and the enterprise gateway is greyed out. 

[txxt]

This is likely your new dataset is against a new data source, taking pc gateway as example, your old gateway is against c:\folder1 as data source, you set credential for your PowerBI.com for refresh. If new data source is now in c:\folder2 then you have to create 2nd gateway and set up access properly. Hope it helps.