Switch databases

vannda21  thanks for the reply.

But unfortunately, that i not my ask.

Let me try to make it more simpler way.

I have built 15 reports by connecting to one database as of now and lets call it as DB1 and this DB1 is having data of related to TENANT1. TENANT means, lets call it as a client but not the tenant we have in power bi.

So for each client we have individual databases been built in my azure sql server.

like CLIENT1 --> DB1, CLIENT2 --> DB2, CLIENT3 --> DB3 .......CLIENT600 --> DB600

All these databases has 4 dim tables and 1 fact table which has same schema.

So now, as i have already built 15 different reports like, REPORT1, REPORT2 ---- REPORT15 with different requirements by connecting to DB1 as source.

I have published these reports to power bi service as well, and all these reports are pointing to DB1 of CLIENT1 from my azure server.

for all the other clients, these 15 reports will be having same template. Means same calculations, visuals, filters, modelling, but it is just the database for that client should change.

I have created Parameter for Database, now i can go to power bi service settings --> Parameters and i can manually change that parameter value from DB1 to DB2 or DB3..etc. But this change of parameter is can be done only through the user or developer who has that access to edit.

lets call USER10 when logged into power bi service, he should see the data of these reports for DB10, and he is just an viewer, that means he cant go to settings and change the parameter to DB10 right.

Now I am looking for a solution where i cam make that parameter change automatically based on RLS or Dynamic M Query parameters or Report url parameters filters.

Because for these 15 reports, already 15 datasets been built in power bi service.

If i have to built reports for other clients with their specific database as source, means i will end up having 600clients*15reports*15datasets.