Do you mean connecting to SQL-DB and use the data to create reports with power bi,
then change the data source to SQL DW or Cosmos DB and use the same report?
If the fields in different database have the same meaning, you could select "edit queries"->"data source setting",change with other data source and give the correct credential.
Or you could have a look at power bi dataflow
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.