I am trying to connect PowerBI desktop to Azure Cosmos DB. When I am opening the interested dataset, it is unable to load and generate error "DataFormat.Error: Duplicate name 'privacyEntityType'"
I checked the entries in this collection in Cosmos DB and couldnt find any duplicates in any of the document. There is only one field with name "privacyEntityType".
Can someone tell what is the real problem here? Does it mean that among N number of documents there could be one which has 2 "privacyEntityType"? It is highly unlikely. As far as the duplicate name is concerned, I manually checked all the items of a cosmos db container for which I was getting the error andnoneof the item contained duplicate name. In fact tried creating a record with duplicate key and cosmosdb does not allow it. It dedupes as soon as well save it.
Can someone help what is the issue here? Or any other way using which I can connect to CosmosDB from PowerBI?