Forum Discussion
Dynamically change data source
Not sure you can have the users select the server and it change dynamically. If your using the cloud version then you cannot change parameters on a published report.
The only way that would work is if you had 5 sets of queries for each of the server/dbs that are all merged and then filtered by the users or using row level security.
The other option is a sort of menu that links them to the relevant dashboard based on the selection.
Download the SSIS Dashboard for my example and look at the queries for an example of a parameterised Server and db.
Hi
I need to parameterize server name and the db name, can you show some example? We would want the users to choose the server name and dbs name but just lunch the dash and get related to them data/report
Not sure you can have the users select the server and it change dynamically. If your using the cloud version then you cannot change parameters on a published report.
The only way that would work is if you had 5 sets of queries for each of the server/dbs that are all merged and then filtered by the users or using row level security.
The other option is a sort of menu that links them to the relevant dashboard based on the selection.
Download the SSIS Dashboard for my example and look at the queries for an example of a parameterised Server and db.