Unable to remove my personal data gateway

[Prathyush]

Hi , 

I am unable to change my old Peersonal datagateway which i created while testing. Now i have my on premise datagateway but my power BI is still looking for the old one. 

 

[v-shex-msft · Accepted solution]

Hi @Prathyush,

Based on your screenshots, I'd like to suggest you check your datasource first. It seems like you haven't correct setting the datasource.

Reference link:

Manage your data source - SQL Server

After these steps, if this database support both gateway, you can switch it at setting -> datasets.
In addition, I'd like to suggest you delete the original test report and publish a new one to test.

Regards,

Xiaoxin Sheng

[Prathyush]

Thank You Xiaoxin Sheng,

It was because my dataset was having an excel source.When Removed it, it started Working.