Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Farhad88
Helper I
Helper I

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

1 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.

 

 

View solution in original post

8 REPLIES 8
Farhad88
Helper I
Helper I

Dear @v-xinruzhu-msft and @lbendlin ,

 

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

Best regards,

Hossein

And then there is this 

 

MPARAMETER – DAX Guide

v-xinruzhu-msft
Community Support
Community Support

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.

Hi @v-xinruzhu-msft,

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

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.

 

 

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

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

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors