PowerBI Gateway - Can't save path/sql changes

Hi , jrscaletta 

If you want to  change the source of datasource in service ,you must  modify datasource of original pbix file on desktop and then republish it first.  So that  the source in your model will match the source in the gateway .

Please  follow these steps:

1.Copy a new original desktop pbix file and modify theDataSource Settings

Transform Data ->Datasource Settings ->change source ，then enter new servername:portname and database name.

2. Edit the new datasource credentials and  apply changes.

You will refresh the report with the new data source data if the data source is successfully switched.

Otherwise, please compare whether the table structure has been changed in the newdata source, which may cause conflicts between the original fields in the model and the fields in the new data source.

3. publish the new pbix file to service 

4.Settings->Datasets->gateway connection-> select "EMBGATEWAY"

 You will find  that the datasource name will be changed from SqlServer{"server:"localhost\\rac...........""}  to the SqlServer{"server:"newservername","new database"}

If you have  already added  new datasource "SQL" to gateway in "Manage gateway ", you will be allowed to  map  to the  corresponding data source.

Best Regards,
Community Support Team _ Eason