On-Premises data Gateways missing from Datasets

[clemoj]

The On-Premises data Gatway connector is installed on a dedicated Server 2019 instance. It is configured to run as the NT Service\PBIEgwService. 

Logging into the app.Powerbi, viewing the "Manage connections and Gateways", I can see the gateway (TrocPowerBi), and the Status states "Online".  

I have configured 4 SQL data sources on that (TrocPowerBi) Gateway Cluster. 

When I navigate on App.PowerBi to the Settings->Datasets, this Gateway (TrocPowerBi), nor the SQL sources are not listed.

The only disconnect I can see, is that the installed On-Premises Data Gateway does not list the TrocPowerBi by name in the Status/settings. However the documentation on setting up an On-Premises Data Gateway doesn't show any named gateways either. I can find a singluar reference to the TrocPowerBi Gateway Name in the log files exported.

[Anonymous]

Hi @clemoj ,

Please check:

• The data source information doesn't match what's in the underlying dataset. The server and database name need to match between the data source defined for the on-premises data gateway and what you supply within Power BI Desktop. If you use an IP address in Power BI Desktop, the data source for the on-premises data gateway needs to use an IP address as well.
• There's no data source available on any gateway within your organization. You can configure the data source on a new or existing on-premises data gateway.

Best regards.
Community Support Team_ Caitlyn

[clemoj]

The Gateway is non-existent in PowerBi desktop or App.PowerBi Datasets.  There is nothing to compare. Troc-PowerBi is missing from the available DataSets to use in Reporting/dashboards/etc.