How to change the data source of a semantic model

[JonathanChan]

I am using the on-premise data gateway for the data source. However, the gateway I would like to choose is displayed as "Not configured correctly". I believe that the issue is that the data sources in this semantic model (the database host and server information) is not matched. I would like to know how to chnage the data source of the semantic model so that I can connect to another gateway.

[Tahreem24]

@JonathanChan  I suggest, first change the data source connection in pbix file from desktop and then re-configure it from data gateway online.

[devesh_gupta · Accepted solution]

@JonathanChan 

1. Open Power BI Desktop with the semantic model.

2. Go to Transform Data → Data Source Settings.

3. In the Data Source Settings window, find the data source that is causing the issue and click Change Source.

4. Update the server name, database, or other connection details to match the correct data source.

If you find this insightful, please provide a Kudo and accept this as a solution.

[JonathanChan]

The connection string of the SQL server must match the one in the on-premise data gateway. There is why it is showed as "Not Configured Correctly".

After changing the data source settings in PowerBI Desktop, the connection string is now matched with the one for the on-premise data gateway. It can be selected in the on-premise data gateway now.