Forum Discussion
Cannot validate relationship for tables in direct query mode
I have two versions. table a to table b is import-import and the relationship validation works. If it is import-direct query, the relationship validation fails. Same data set. Different result.
Community SupportHi Dragut ,
Thanks for the clarification.
You can perform certain checks in this case apart from insuring both tables follow same data type when forming a relationship.
1.Check the text for white space, trim the column.
2.Direct Query mode has some limitations on the features it can support, especially when it comes to relationships.
In some cases, features like bi-directional filtering or certain DAX expressions may not work when one of the tables is in Direct Query mode. Check if your relationship involves such unsupported features.
Additionally, you can visit this link where the issue was addressed earlier.
Solved: Relation between Direct Query Table and Import tab... - Microsoft Fabric Community
Hope this helps!
Regards,
v-aatheeque
If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!