Forum Discussion

Titatovenaar2's avatar
Titatovenaar2
Advocate II
3 years ago

Field parameters in local composite model with DirectQuery, unsupported?

Hello everyone,   We currently use field parameters in our local composite model with DirectQuery, which Microsoft states as being supported:  You can't create parameters in live connection data ...
Need Help
joaoribeiro's avatar
joaoribeiro
Impactful Individual
3 years ago

Hi Titatovenaar2 ,

 

Unfortunately Field Parameters are not supported in Composite Mode with Direct Query, only for Live Connection. My team has been suffering with this issue for a while. Possible workarounds are recreating the field parameters in the composite mode, which can be bad for maintenance, or use calculation groups to achieve the same result, as they are supported in Direct Query.

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️or giving it a kudoe 👍

Thanks!
Best regards,
Joao Ribeiro

Titatovenaar2's avatar
Titatovenaar2
Advocate II
3 years ago

Thanks for confirming and the fast reply. I think I will try the calculation group route with a switch measure to recreate the field parameter functionality inside the main model and make it hidden for the users.