Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Parameterized data source bound to field

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.

Community Support
Community Support

Hi, @jtspilker ;

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

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.

Helpful resources

Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

Top Solution Authors