Unavailabe gateway option

[Aleli]

Hi,

All of my Power BI reports are connected into one data warehouse, and I have already installed an on-premise data gateway.

The gateway is working well for some of the reports, and I don't understand why it's not available for others. Can somebody tell me why the gateway connection option is disabled for some reports? Any idea or suggestion will be highly appreciated.

Regards,

Aleli

[kcantor]

@Aleli

Generally, when the data gateway is unavailable, it is due to having sources that have not been added to the gateway. If I change a source to include a new point of origin (and forget to add it), the data gateway will be greyed out. Check the reports or data sets where the gateway is not an option to make sure all queries are included.

[Seth_C_Bauer]

@Aleli Are you getting any errors with the reports that can't connect, or is it just gray?

Do you have other data sources combined in the dataset with those other reports?