Direct Query Where Clause

[Goofr]

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

[TomMartens · Accepted 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.