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 use parameters for all my connections. You can see an example of parameterised queries from different sources
in my SSIS Dashboard.
http://community.powerbi.com/t5/Data-Stories-Gallery/SSIS-Catalog-DB-Dashboard/td-p/244677
Note changing server or database will need the security confirmed again.
I tend to have a test version then when it's complete I save as a template.
I then create a new version with the parameters changed from the template for each of our SSIS Servers. Similarily you can publish a new version to each workspace/content pack in the cloud.
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.
