Parameterized data source bound to field

[jtspilker]

I want end users to be able to choose between pulling in test data or prod data in the report. I have a test and prod SQL server. Inside are identically named databases and schemas, so all I need to switch is the server name. I've successfully created a parameter that defines the server name, and all works fine when I change the parameter via the usual method ("Edit Parameters") in desktop (haven't yet tested in Service).

However, I've also created a table with the possible values for my sql server parameter, and bound that field to my parameter. When I throw my bound field into a slicer, nothing changes in my data, and the parameter value doesn't change either. Am I missing something here?

If it's relevant my datasource is connecting via Direct Query.

[v-yalanwu-msft]

Hi, @jtspilker ;

Sorry, I am not familiar with this area, you can refer to the following link.

https://docs.microsoft.com/en-us/previous-versions/aspnet/ms228051(v=vs.100)

https://docs.microsoft.com/en-us/previous-versions/aspnet/xt50s8kz(v=vs.100)

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.