Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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!
@topographical12 , It seems like you are trying for the Dynamic M parameter, that can be used for Direct Query
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.