I have been using .NET SDK to query Azure Cosmos Db and using DISTINCT keyword in code gives accurate distinct values from a container.

However, using that same query in Azure Portal / Azure Storage Explorer doesn't give accurate results. Sometimes we get same value more than once. I was told in conversation with different team that this is an issue with Azure SDK for Node JS so I was posting the issue here again.

Following are my screenshots for your reference: