Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
@FaasBoers , Check if you are hitting one of the limitation
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |