Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Enterprise Gateway greyed out

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? 

 

 

4 Replies

  • nineruteAE's avatar
    nineruteAE
    New Member
    10 years ago

    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's avatar
      Anonymous
      Not applicable
      9 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    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's avatar
      txxt
      New Member
      9 years ago

      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.