Issue with Dynamic M Keyword Search Forcing Composite Model

[hrafnkel11]

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 Create Table in Power BI in order to bind the parameter, I am unable to convert this to a DirectQuery report (currently it's Mixed/Composite). The reason why I want to do this is so that I can update the "Max Parallelism Per Query" value to potentially increase performance, which I believe requires a DirectQuery model.

Is there any way to bind a user-entered parameter to a table in Power BI WITHOUT forcing the model to be Composite?

This is the table to which the parameter is bound:

This is how the user searches the column in Snowflake:

[Anonymous · Accepted solution]

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]

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.

[hrafnkel11]

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?