Hi there!
I've recently had a lot of success with binding paramters to slicers and underlying queries (against a Snowflake table), but I wanted to rather have a table use a dynamic query to import data via import mode rather than use direct query so that data is imported dynamically based on changing slicer values. What I have is:
Slicer 1: "ID"
Parameter 1: "P_ID" within the query editor, that I've bound to Slicer 1
Fact table: "F", and the query for this is "SELECT * FROM F WHERE ID = #{P_ID}"
When I include Slicer 1 on my visual and change the value for it, the visual of the Fact table doesn't change, even when I hit the refresh button. However, when I go to Transform Data, and then edit parameters and then update the value there, the visual of the fact table updates correctly.
My question is: am I doing something wrong with my slicer? Or do I need to refresh the visual a different way on changing slicer values (or change any setting), and if this isn't possible, is there a way for me to get the "edit parameters" screen into the visual to make it more user friendly?
Thanks!
