Forum Discussion
Advocate IDuplicate values are detected from data source. If it's a DirectQuery model, please make sure data
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!!
Hi Klaudia_00 ,
We tried to reproduce the problem under the version(2.123.742.0 64-bit (November 2023)& 2.124.1052.0 64-bit (December 2023)) , but we were unable to reproduce it. Here are some steps we have tried:
1. We have used import mode and direct query mode to get data and generate visualiztion in powerbi desktop.
2.Three of the tables in the data obtained by the direct query have many-to-one and many-to-many relationships, one table with duplicate values and two tables with non-duplicate values.
3.After pubish to the service and refresh on-demand, the report displayed correctly.
To troubleshoot the problem further, please provide us with more information such as relationships between your tables, data source types and files to test .
Please make sure not attach sensitive data before sharing the files.
Best Regards,
Albert He