Table for parameter in Advanced Editor

[FaasBoers]

Hi, I'm using 3 parameters in my SQL query. I am using a slicer to change the value of the parameter. 

Parameters: StartDateParameter, EndDateParameter, CardValueParameter.

I've created a table "StartDate" and "EndDate" and binded these to StartDatePara en EndDatePara. In my report I have 2 slicers where I can select the date. On select the query changes. 

For CardValuePara I'm using an import table "Employees". Columns CardNumber, Name. I've binded CardValuePara to CardNumber. When I create a slicer for CardNumber everything work fine. But when I create a slicer for name, CardValuePara doesn't change. 

Does somebody have a solution for this?

[amitchandak]

@FaasBoers , Check if you are hitting one of the limitation

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters#considera...

[FaasBoers]

It looks like I'm trying to do something that it's not made for. 

This is my m query:

StartDate = StartDateParameter, //#datetime(2023, 1, 1,0, 0, 0),
EndDate = EndDateParameter, //#datetime(2023, 12, 31, 0, 0, 0),
Card = CardValueParameter,

Source = Sql.Database("MyData", "MyTable", [Query="
SELECT *
FROM MyTable
WHERE TimeStamp >= '" & DateTime.ToText(StartDate, "yyyy-MM-dd hh:mm:ss") & "' AND TimeStamp <= '" & DateTime.ToText(EndDate, "yyyy-MM-dd hh:mm:ss") & "' AND OperatorId = " & Text.From(Card) & ""])

in
Source

The "Card" table of my "Employees" list is binded to the CardValueParameter. 

When I create a slicer for the "Card" field, the query changes. But when I create a slicer for the "Name" field nothing changes. I'm looking for a workaround