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.

Anonymous's avatar
Anonymous
Not applicable
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

Thank you! Unfortunately, this use case currently requires an open ended search from the user. It's possible once we collect some data on frequent keywords searched, we'll be able to create a dictionary that can be referenced, but until then it sounds like we'll be stuck with a composite model.