Forum Discussion
Cannot validate relationship for tables in direct query mode
I am asked to change the storage mode for certain tables from import to direct query mode. I have to delete them and rebuild from data sources with direct query. However, after rebuilding I encounter...
mdaatifraza5556
Super User
Super UserHi Dragut
One of the reasons may be the Data Type of the Relationships.
Go to Power Query ---> Select the columns used in relationships ---> Ensure they have the same Data Type in both tables.
If this answers your questions, kindly accept it as a solution.
If you found this helpfull then give kudos.
All of them are of text data type and I have made sure there is no null or missing values in them. But the relationship could not be validated and visuals don't work.