Forum Discussion
unable to remove offline gateway
I had a system set up as my gateway, however it encountered a failure and is no longer bootable. A gateway was installed on a replacement machine as a new gateway instead of migrating.
Now my data sets are still referencing the old gateway which is no longer available. The new gateway is configured and the data source added, but the data set doesn't seem to recognize it.
I tried uninstyalling and reinstalling the gateway to do a migration of an existing gateway, however my only option to migrate is the new gateway that was previously installed on the same machine.
How can I get the data sets to refresh through the new gateway?
Hi timsalch,
In Power BI Desktop, please delete the Excel data source in your PBIX file, then republish it to Power BI Service. Then you should be able to use on-premises gateway to set schedule refresh for this dataset.
Thanks,
Lydia Zhang
14 Replies
timsalch In power bi service on top right hand corner click settings wheel icon -> Manage gateways -> then under list of gatewas you should be able to click ellipses (three dots) by hovering over the name of your old gateway and click Remove. That may not automatically switch your reports to the new gateway and you may need to remove existing reports from pbi service and republish for them to start usign new gateway.
Thank you for the reply.
When i go to the manage gateway the orignal gateway is not there, only the new ones. I removed all data sets and re-uplaoded form power BI desktop. However still when I go to scheudle refresh it tells me the gateway is offline and is pointing to the old gateway. Mange gateways only shows the new gateway.
Hi timsalch,
Based on your description, you want to switch Personal gateway to On-premises gateway and want to schedule refresh for your dataset by utilizing the On-premises gateway. If that is the case, please firstly add data source under the On-premises gateway, and make sure that data source information you add under the gateway matches exactly what you configure in Power BI Desktop. Assume that you connect to SQL Server database from Power BI Desktop, please ensure that server and database name completely match between Power BI Desktop and the data source within the on-premises data gateway.
In addition, please uninstall personal gateway from Control Panel. If the personal gateway is not removed completely, you can use CCleaner to clean up registry of personal gateway, manually delete personal gateway folder under C:\Program Files.
Thanks,
Lydia Zhang
