Duplicate value causing refresh issue but value is not dupplicated

[Anonymous]

Hi there,

We are using OData with Azure DevOps for a bunch of our teams here. We have various .pbix files published and scheduled to refresh daily, however some (not all - despite using the same query format) are getting the following error:

The query used is https://analytics.dev.azure.com/[Collection]/[ProjectName]/_odata/v3.0-preview/Dates?%20$filter=Date...

I have checked in my browser:

and in PBI Desktop:

and this value is only appearing once...

[Anonymous]

Hi @Anonymous ,

Please try change the Cardinality to 'Many to One'.

uncheck the "Autodetect new relationships when data is loaded." 

Or you may reach  the DATA Load tab,  cleared the Data Catch and Q&A Chache.  

Best Regards,
Community Support Team _ Caitlyn

[Anonymous]

Yes thanks fully aware of the different workarounds - but it doesn't address the issue of this being inconsistent across pbix files (despite being the same table) and saying there are duplicates when there are clearly not...

[Anonymous]

I have the same issue. I can refresh the whole data in Power BI desktop but when I refresh using the power BI service the duplicate value error randomly appears but when I query the data it only show 1 entry. Very annoying and disappointing and I can't find any help. I can't even file a ticket. I hope someone can help and give proper direction.