Forum Discussion

Klaudia_00's avatar
Klaudia_00
Icon for Advocate I rankAdvocate I
2 years ago
Solved

Duplicate values are detected from data source. If it's a DirectQuery model, please make sure data

Together with my team, we have a problem with a report which is in a mixed mode (1 import table, other tables in Direct Query). It has been working for now more than a year. Yesterday, we encountered...
Need Help
  • plxtime's avatar
    plxtime
    2 years ago

    For anyone who has previously posted to this thread, an update from my side. I submitted a support case to the product team the day this issue started happening. I received an update from them today (after sending them reproducible steps to get the issue) that the issue is fixed. And I confirm for me that my impacted reports are working again. Thanks to the PBI product team!!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello everyone,

We've encountered same challenge with semantic models using direct query mode to AWS Snowflake. Please take a look at the issue and consider voting for it:

Link to the Issue

  • AnasPBI's avatar
    AnasPBI
    New Member
    2 years ago

    Hello @everyone , 

    As i have already shared with you, we have encountered the same issue, and managed to correct it.

     

    Correction : We have applied the Collate function with insensitivity specification ('en-ci') on the Text columns in our table. 

    this is an upgrade on the app power bi that seems to correct the sorting issues when mixing case sensitivity and insensitivity in the same table.

     

    Please let me know if it works for everyone.

     

    AnasPBI