Forum Discussion

hrafnkel11's avatar
hrafnkel11
Helper I
2 years ago
Solved

Issue with Dynamic M Keyword Search Forcing Composite Model

Hi - so, I have a working Dynamic M model in which a user can enter a keyword and search for that value in a Snowflake column via DirectQuery. My issue is that since the keyword search requires me to...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi hrafnkel11 

    You can use dynamic M parameters to bind user-entered parameters directly to your queries. This approach allows you to keep the model in DirectQuery mode. However, it requires that all possible values for the parameter be enumerated ahead of time.
    Unlock the power of dynamic parameter binding for ... - Microsoft Fabric Community

     

     

     

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

hrafnkel11's avatar
hrafnkel11
Helper I
2 years ago

I guess a follow up question (which may be my answer)...is the below setting effectively doing the same thing as setting "Max Parallelism Per Query" in tabular editor?