Forum Discussion

ravdha85's avatar
ravdha85
Frequent Visitor
3 years ago
Solved

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

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

 

 

Need Help
  • DataInsights's avatar
    DataInsights
    3 years ago

    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.

1 Reply

  • DataInsights's avatar
    DataInsights
    Super User
    3 years ago

    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.