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.

    • joaoribeiro's avatar
      joaoribeiro
      Impactful Individual
      3 years ago

      Titatovenaar2  glad to help. Wish you success in the project 🙂 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Were you able to get something to work? I think I am having a similar issue with field parameters not allowing refresh in the powerBI service. I am using field parameters along with a drowndown selection to allow users to change data the visuals are showing based on the drop down selection. Not sure if calculation groups can be used in place in my case. I will have to look into that.