Can you use Power Query Dynamic M Parameters for multi-select?

This is the most powerfull video eveeeer! It saved my life! thanks a lot!

Hey Patric,
this Binding Parameter option is only available in Directquery Mode,
can we do something like this in Import Method?

Hi,
thank you for the video. It's great! Have you tried multi-select for parameters of date type?

in tableau it is possible to pass parameters to the sql query that is needed so that the data is live in power bi how could it be done.

can this be achieved in Excel? ...using powerquery of course. Thank you.

This is great thank you so much ! , does anyone have an extended example of using say 4 slicers in combination using this method ?

Can you do it in a SQL Direct Query? I needed to do this using Report Builder which couldn't connect directly to databricks, so I had to create the dataset in Power BI with M-parameters.

Q: Great video as usual, thanks ! How can we do if we want to pass any values instead of a multi select slicer to do like a « what-if parameter » using Direct Query ? Chris Webb has written a great post about it on January 2023 but my business users are not very fan of using the « Filter by List » visual, they would like to use a slicer as a what-if parameter…

Its Already there in powerbi Dynamic multiselect once we click control multiselect work on dynamically

good one,
But why we need to use dynamic M ,instead simple slicer ?

Hey Patrick,

With DirectLake mode, Dynamic M Parameters does work ?

Informative one !

This is great! I had to watch this to prepare for the power bi pl-300 exam. Maybe you guys can make a video on how to prepare for it??

Hey Patric,
Performance wise it is bit slow since you are loading data first then filtering it out. I would suggest you to pass the parameter directly in where clause.

Wow! This is amazing

Q: Hey Patrick, I use a lot of MDX in dataflows to query our multi-dimension database, is it possible to pass through dynamic parameters into my select statement? Ex. Choose a month in the dataflow and it update my code. Thanks!!

Great Video! In this technique, is the country filter applied after all the data is pulled into the dashboard or, are the filters passes to the underlying source and only required data is fetched?

quick question, when will we need it? Cuz seems it's similar to the slicers. Please advise. Thanks

Hi Patrick
Love your videos from India