Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I have a model with two datasets (Project and Sales) linked on ID. When I filter my report on Project.ID the query sent to the database has a where caluse (WHERE Project.ID = 123). When I filter on Project.Code the same query gets a where clause (WHERE Project.Code = 'ABC').
How can I force Direst Query to use the ID instead of the Code?
Thanks in advance,
Frank
Solved! Go to Solution.
Hey,
you can't.
Power BI can't know that there is one to one relationship between the two columns even if both columns reside in the same table.
Hey,
you can't.
Power BI can't know that there is one to one relationship between the two columns even if both columns reside in the same table.
User | Count |
---|---|
81 | |
76 | |
69 | |
68 | |
54 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |