Parameter for database connection? (different azure environments with the same sql database)

[Anonymous]

We have a web application and in this web application we want to embed some powerBI dashboards/Reports.

Now we have different customers. Each customer gets his own Azure environment (web application and sql database). However the web application and the database are the same for each customer.

Now if I create a powerBI report I connect to the database server like "customer1.database.windows.net" and "customer2.database.windows.net" and so on. However the reports are exactly the same. So I would prefer to create one report and deploy that to all environments without the need to make specific changes for each environment.

Is there a way to achieve that?