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!!

AnasPBI's avatar
AnasPBI
New Member
2 years ago

Hello , 

We are facing the same problem : ""Couldn't load the data for this visual

Duplicate values are detected from data source. If it's a DirectQuery model, please make sure data source collation is consistent with this Analysis Services model.""

 

We checked the data and there's no duplicates in the source , table is working fine in the desktop version. 

 

Please post when you find an answer or solution to this . 

 

Thank you .