Forum Discussion

Farhad88's avatar
Farhad88
Icon for Helper I rankHelper I
2 years ago
Solved

How to access the current value of the dynamic parameters, not their default value, in imported mode

Hi every one!

 

I need to access the current value of a parameter selected by the user using a slicer, in imported mode. However, when I try to use the parameter's value in M Query, it always reterns the default value of the parameter, not the value which is seleted by the user!

In the DirectQuery mode, we would have the current value of the dynamic parameter without any problem.

What can I do to have it in the directed mode as well?

 

Thanks and best regards,

Hossein

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Farhad88 , 

    Thanks for your quick reply, the current version cannot support it by import mode, if you want to change the paramater value, you can only edit it in power query editor or data source setting in Service when you publish the report to the service, you can consider to move your datasource to SQL so that you can use the direct mode.

     

    Best Regards!

    Yolo Zhu

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

     

     

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Farhad88 

    The dynamic paramater is supported in direct query mode, you can refer to the following link, if  you want to use the dynamic paramater, you need to change the import mode to direct query mode.

    https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters#prerequisites

     

     

    Best Regards!

    Yolo Zhu

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

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      remember that you cannot switch from import to direct query unless you patch the binary inside the zip file.

      • Farhad88's avatar
        Farhad88
        Icon for Helper I rankHelper I
        2 years ago

        Hi lbendlin ,

        Please let me know how we can do that? (i.e., patching the binary inside the zip file)

        Do you think we may change the type of a Web data source (e.g., Rest API) to direct query? (as far as I know the web data sources are in directed mode by default)

         

        Best regards!

        Hossein

    • Farhad88's avatar
      Farhad88
      Icon for Helper I rankHelper I
      2 years ago

      Hi Anonymous,

      Thanks for your reply. But why this very useful feature should be limited to direct query mode? 

      Do you think that, in the future versions, we may see dinamic parameters working in the imported mode as well? (we really need it in our current project)

       

      Best regards!

      Hossein

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Farhad88 , 

        Thanks for your quick reply, the current version cannot support it by import mode, if you want to change the paramater value, you can only edit it in power query editor or data source setting in Service when you publish the report to the service, you can consider to move your datasource to SQL so that you can use the direct mode.

         

        Best Regards!

        Yolo Zhu

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

         

         

  • Farhad88's avatar
    Farhad88
    Icon for Helper I rankHelper I
    2 years ago

    Dear Anonymous and lbendlin ,

     

    Thanks for your information. I used another strategy to achieve my goal.

    Best regards,

    Hossein