For some data sources such as databricks, Power BI doesn't allow user to change the data source (e.g. host) later.
Under the Data Source setting, the 'Change Source' will be grayed out.
One way to change the data source URL, is go to each of the Queries, go to advance editor and edit the first line of code
e.g. let
Source = DatabricksMultiCloud.Catalogs("dbc-xxxx.cloud.databricks.com", "sql/protocolv1/o/111/111-222-xyz", [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null]),
The change of hardcoded url is very not handy when deploying reports from dev to test to prod, because you don't want to change the report at all.
One way is to parameterize the data source URL, e.g. put in a host and a path parameters.
Then change the query to use the parameters
let
Source = DatabricksMultiCloud.Catalogs(host, path, [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null]),
Once deployed to PowerBI service, the Semantic Model / data model setting has a section for Parameters, and you can repoint the report to the corresponding environments