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.
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.
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |