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.
I faced the same issue. The report was working fine previously. I changed data storage type for a small table to Dual from Import and it started working again. Not sure if this has to do something with PBI ubdate.
Klaudia_00Thanks for sharing. I was wondering how did you manage to switch the table from Import to Dual mode?