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!!
I actually found a solution yesterday. There was no duplicity when I checked the data and it was working on Desktop and the strange part is that it is historic data which has not changed in a year and the report is being used on Web for that long. Anyway, the fix I found was to remove a relationship inside the Data Model. I had a 1 to many where the "many"side was going to another 1 to many. And that made the report work again. Although I would still be interest to know why now the error. It seems a new version of Power BI extra check... And my report is only using Direct Query.
Advocate IThank you for sharing. We actually have a simple schema with one to many relationships and one way filtering. For one table we have filtering in both directions - it didn't help when we changed it to one way.
Someone from my team also suggested changing the relationship to "many to many". I know it sounds ilogical if your relationship is 1 to many, but maybe worth a try.