The data gateway option is disabled

[ThalesFerraz]

Hello there,

According the image below, the data gateway option is disabled.

Spoiler

but, my data gateway is working on and all connections is registred.

Necessary connections:

Spoiler

 

 

Registred connections:

Spoiler

 

 

[v-yuezhe-msft · Accepted solution]

Hi @ThalesFerraz,

Could you please elaborate more details about your scenario? We need to verify that if you install different types of gateway on the machine and if you add data sources under Personal Gateway or other Gateway.

If you add data sources under Personal Gateway, the phenomenon in the above screenshot is normal. However, if you add data sources under other type of Gateway such as Enterprise Gateway and wants to use the Enterprise Gateway, please make sure that the data source configured for the Enterprise Gateway are configured exactly as the Personal Gateway, otherwise the “Use a data gateway” option will be disabled. For more details, please review this similar thread.

Thanks,
Lydia Zhang

[ctembe_bi]

I am facing similar issue. Posted in community. 

Please have a look at:

https://ideas.powerbi.com/forums/360879-issues/suggestions/16616575-gateway-connection-disabled

Thanks.

EDIT:

Also observed that, while ADDing DATA SOURCE, it accepts SQL SERVER INSTANCE name instead of SQL Server IP/Name
(Which is usually accepted in SSMS).