Forum Discussion
Power BI Dynamic Query Binding Issue: Slicer Not Refreshing Data + Mysterious '?' Icon
Hi Aacuabo ,
The question mark (?) is the symbol that the specific field is a dynamic binding to the query you can see that on the documentation:
What is the type of model you are using Import or DQ?
Be aware that for the dynamic binding to work the Fact table needs to be DQ and the dimension needs to be import or Dual model, creating a composite model.
Hi Aacuabo
Dynamic query binding in Power BI can be tricky, especially when working with large SQL sources.✅ 1. What does the question mark (?) icon mean?
The ? icon next to the bound column in Model View indicates that the binding is not fully validated. Common reasons:- The parameter is not correctly linked to the field.
- The data type of the slicer column does not match the parameter type.
- The parameter is not being used in a query that supports dynamic binding (e.g., query folding is broken).
Essentially, Power BI is saying: “I see the binding, but I cannot guarantee it will work as expected.”✅ 2. Why does the slicer not refresh the data?
Dynamic binding only works when:- The parameter is used in a native query that supports query folding.
- The slicer column and parameter have matching data types (e.g., both text or both date).
- The report is set to DirectQuery mode (dynamic binding does not work in Import mode).
- The parameter is referenced in the query in a way that Power BI can rewrite dynamically.
If any of these conditions fail, the slicer will change visually but will not trigger a new query.✅ Quick Troubleshooting Tips
- Check Data Types
- Ensure MonthYearForSlicer and p_SelectedMonthYear are the same type (e.g., text or date).
- Validate Query Folding
- In Power Query, right-click the last step and check if “View Native Query” is enabled. If not, folding is broken, and dynamic binding will fail.
- Confirm DirectQuery
- Dynamic binding only works in DirectQuery mode. If you are using Import, the slicer cannot trigger a new query.
- Rebind Parameter
- In Model View, rebind the parameter to the slicer column and ensure the question mark disappears.
✅ Why is this happening with large SQL sources?
Dynamic binding relies on query folding. If your SQL query is too complex or includes transformations that break folding, Power BI cannot rewrite the query dynamically.If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.
Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.
Hello Aacuabo,
We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
Thank you.