Forum Discussion
Changing database selection from power bi Web App
You can parameterize the server/database connection but after changing that value, the model would need to be refreshed and everything about the structure of the tables would need to be identical.
I would think it would be easier for you to set up the model to include all the data from all databases and then add a slicer to the report to only show what is required.
The only way passing a parameter would work for users consuming the report is if you were using direct query and that's not a good idea.
My thinking around pulling all the data in would be using Power Query to combine the data from all databases.
so queries,
stage_databaseA
stage_databaseB etc.
combined_databases
In the combined query you can ensure data exists for filtering via slicer or RLS.