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!!
Yup, same here. Just stopped working on the web version recently. I have a mixed mode report just like yours, 1 import and other tables in Direct Query. Mine work correctly on the desktop version as well.
I wasn't able to fix the report using the existing tables. Originally my report was setup to just connect to the tables and then build relationships. Then build the report from those tables.
The only way I was able to fix it was to abandon that completely and write a custom SQL query for the report I was making. Once I did that, the report is able to run just fine. It will just be annoying when a change is requested, I'll need to edit the qeuery instead of just adding a field from the tables.