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.
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.
Yes I agree with you, that is our long term plan to have one database that stores everything. The paramater worked after I set up a gateway on my computer. Do you know if it is possible for the end user to update the parameter if I share the power bi report with them?
