New on-prem gateway disappeared after gateway upgrade

[Cathryn]

Hi All

This is really strange.  When I took over the BI role in my company there was a gateway installed that I couldn't access b/c I didn't have the recovery key so I created a new one GatewayII.

Yesterday I did the upgrade and now when I go to PowerBI, the original gateway is working and my Gateway II isn't.  When I go to the server that has the on-prem gateway, I open up the interface and it shows the original Gateway active and good to go.  I can't figure out how to find GatewayII.

So, can anyone help me with finding my 2nd gateway and fixing it so it's online or changing my reports to point to the original gateway?  I can't figure out how to switch gateways for the reports.

Thanks

[v-qiuyu-msft · Accepted solution]

Hi @Cathryn,

If the original gateway and GatewayII are created under the same Power BI account, though you update the data gateway, those two gateways should available in Manage Gateways. In your scenario, please check if those two gateways are created under the same Power BI account firstly.

To configure the dataset to use original gateway, you need to create all data sources under original gateway use the same connection information as in the dataset. Then you can go to dataset settings to select the original gateway. Assume the dataset only have one SQL Server data source, you can follow this article: Manage your data source - SQL Server.

Best Regards,
Qiuyun Yu