I'm trying to use Direct Query in a model. It is loading and working, but when I try to associate the dimensions, it is not working.
As you can see, the direct Table has the same field name that the dimension (Especies). The Especies table has the value 11, but when I try to show the name, that is stored in the Dimension table, I get a Null and not the name.