Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |