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

[Farhad88]

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

[Farhad88]

Dear @Anonymous and @lbendlin ,

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

Best regards,

Hossein

[lbendlin]

And then there is this 

MPARAMETER – DAX Guide

[Anonymous]

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#prerequis...

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]

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 · Accepted solution]

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.

[lbendlin]

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

[Farhad88]

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

[lbendlin]

The patch only allows you to revert the change from Direct Query to Import mode for a data source that is Direct Query enabled (ie SQL based).  Web data sources are not compatible with Direct Query.