Relationship Filtering not working in Direct Query but works correctly in Import/Dual mode

[ravdha85]

Hi Experts,

I am using Direct Query mode to pulll Data from Snowflake DB, I have a relationship betweeen Employee and Call Center Tables on Email ID. If I try to filter the Call Log table through Supervisor name on the report , it displays fewer records than expected in Direct Query mode. But on Dual/Import mode the records are displaying as expected. Could you please help me with this?

Direct Query

Incorrect O/P

Import/Dual 

Correct O/p on Dual/Import Mode

[DataInsights · Accepted solution]

@ravdha85,

This might be caused by DirectQuery being case-sensitive and Dual/Import not being case-sensitive. When I encountered this issue, I resolved it by using the Snowflake function INITCAP in my custom SQL.