Power BI Quick Tip: Using Dynamic M Query Parameters with SQL​​

0:00-Introduction
1:49-Illustration
3:04-Parameter Binding Query
4:04-Define Parameters
9:42-Table Bind Parameters
12:16-Add Report & Slicer
14:52-Multi-select M Query Filter
19:50-Bind Multi-select Parameter to Table
21:04- Multi-select Slicer Test
22:36-Multi-select Cross-filter Setup
24:30-Conclusion

[shreekantgosavi]

This is one of most underated video when it comes to advanced power bi
Great work sir

[michaeldoyle]

This video is absolute gold dust and has saved me a huge amount of time. Thanks

[robertosiga]

Very good! Thank you and greetings from the friend of Brazil

[lzhao]

Can the Start Date and End date slicers showing as a calendar date picker instead of dropdown list?

[mp_dev]

Awesome explanation!! You are a legend mate

[shrt]

Great explanation i was actually looking for this ...

[sharavananp]

fantastic, awesome explanations, and great effort !!

[JaipalAnugandula]

Great video. One Question - Can we take date range slicer instead of selecting the particular date in StartDate and EndDate Slicers?
Thanks!

[ajitverma]

Hello, this very helpful, can we use the same thing for RLS in direct query mode?

[kevinmarti]

Hi there

Is there a way to dynamically assign a value to the parameter like using a meassure which returns a value? I know thats currently not available because you cannot bind a meassure but would absolutelly change my game.

[boo-kewr]

It looks like you are using Power BI desktop as I am as well but I do not have the 'Bind to parameter' feature. I looked at documentation and I believe its only for the cloud version. My settings do not have even have the ability to enable Preview Features. Please verify as to whether this is the case as I saw another article posted by Microsoft using the 'Bind to parameter' and never mention if this feature is not on Desktop (onprem) and just on cloud.

Video is great though! Thanks.

[jenyura]

Very useful. Would be great if you could increase screen when you type. I have small screen and cannot see text

[vinayak_sharma]

Thanks for the info. It worked fine on PowerBi desktop but not after publishing it to power bi service.
Getting error "the connection string used for the mashup data source is invalid or the gateway needs to be upgraded to the latest version"
Gateway is have double checked and it is updated.

[msuk-rb]

Instead of drop down slicer, can’t we use the date picker?

[gauthamn]

Hi sir video looks good. I have a stored procedure, i need to pass two parameters dynamically to get the output. Will this solution work ?

[arunkoshyg]

Nice presentation. Its a dynamic report isn't it. I mean values changing on real time basis.

[anandkumarmadireddi]

Great video and awesome explinations. But when I check the backend SQL, both Dynamic M Query and normal filter with in report are having similar query profiles (query execution plan) for database. (in this case Snowflake is the database). Even if we create the report with out dynamic M query, the filters are being pushed down to database query, so that it only return the specific filtered data back to PBI. So can you please explain if there is any specific reason to go for dynamic M query?

[srlabhe]

Nice info, How would I add date flgs as dynamic, my Date Dim has many date flags and I wanted to change M query in such a way that If I use any of date flags it should filter data accordingly

[Patiencelad]

Very clear explanation! Thank you!

Unfortunately, I still can't get this to work. Bind to Parameter on my slicer dim is selected, but it's not binding. Any ideas? I have the latest PBI version. No syntax errors. (single) Parameter is text and &'d with single quotes in the SQL (Server).

[oghdgy]

Hi so I have been trying to do this for work but I coming across the issue where “Bind to Parameters” is not available. I am using direct query to a SQL server and have the preview features set properly. I keep seeing online that you aren’t able to do this with SQL server however you just did it. Any ideas?