Power Bi : Setting up Dynamic Parameters 

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vyR0uAbLdTk.html&ab_channel=DapperDash

I have built models with RLS and Dynamic Parameters together. I don't believe you can apply an RLS rule directly on a table that is using a a field as the Dynamic Parameter, but you can build a model where some datasets leverage dynamic parameters and others RLS rules. And yes, you can use userprincipalname() as a way to dynamically filter a query. You cannot pass the DAX function into the M Query, but there are workarounds that allow you to capture the value from userprincipal() and pass it into a dynamic parameter query. I have done this before. It requires a little bit of set up so that your end user doesn't have to select a filter. In fact, they are unaware that dynamic parameters are going on in the background. Maybe we can find some time to chat and go over this.

@@DapperDash Big thanks for the reply. In my case, I have to parametarize the dataset using client name. And also the userprincipalname () will also configured for each client. Is that possible to use both parameters and rls togather in my case? And could you mention some workarounds to make this work?

Sorry it took me a while to get you the solution: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vyR0uAbLdTk.html

Are you querying against a TSQL data source? (Azure, MSSQL, MYSQL...). I have also seen it bug where I have had to delete the parameter and recreate it.

Thanks for the love Chris. Hope all is well.

no one has this answer

having the same problem. Has anyone found any solutions yet?

i perform query through oracle database and having the same problem, hope there is solution for this

hello guys did you fond a solution ? i cannot found thé " Bind to parameter"

Hello, everyone, it now works in version: 2.112.1161.0 64-bit (December 2022). You only have to wait 5 months, then the solution will come almost by itself. Now I'm happy. If you still have questions, just leave a post.🤩

I am not sure what you mean by changing the filter. But this should work with a custom query. The only reason it could fail is if you are passing multiple values. The example I shared is made for single value parameters

I have a table that contains the name of all the databases on my server and I want to use it as a parameter.

Hey Allard. Good point. I used it recently in a stored procedure at my company. Let me look at putting a tutorial together. It's very similar to the way I set this one up.

@@DapperDash Ah, that is good news. Because I myself tried it and I cannot find a way to call a parameterized T-SQL stored procedure and bind the parameters to user-controls on the dashboard. So I see forward to your tutorial!

hello all , please there 's some update on it ?

Game changer if this one can be figured out . . . Dapper Dash can you provide a video on dynamic parameters for Stored Procs????

​​@@allardbon1967 did you ever figure out how to do this, or a similar workaroubd? Would love to hear a solution, i'm completely stuck

Saddam, There is an example of "Select All" and choosing multiple values here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vNK4xygN8Xw.html&ab_channel=MicrosoftPowerBI You can see the code at 10:54 into the video.

Here is the code you need. You also have to enable "Multi-Select" on the column properties. I can create a tutorial for you if you want: let param = if Type.Is(Value.Type(YOURFILTER),List.Type) then Text.Combine({"'", Text.Combine(YOURFILTER,"','") ,"'"}) else Text.Combine({"'",YOURFILTER,"'"}), selectAll = if Type.Is(Value.Type(YOURFILTER),List.Type) then List.Contains(YOURFILTER,"_SelectAll_") else false, query = "Select * From dbo.YOURTABLE", filter = if selectAll then " " else Text.Combine({" Where COLUMN in (", param, ")"}), finalQuery = Text.Combine({query,filter}), Source = Sql.Database("Server", "Database", [Query=finalQuery]) in Source

Thanks a lot sir, but select all is not working in my case that's why I am worried about. I will watch this video again

@@DapperDash I just tried with SQL SERVER and it is working but with snowflake it not giving me the results I am testing it once again thanks

Yup, you can use a date. The Microsoft documentation page on dynamic query parameters uses a date field as an example: learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

@@DapperDash gtfoh! Man you're the 👑

Ahh there are limitations, Can't use date slicer on it 📅!!!!