Error connecting PowerBI with Azure Cosmos DB

[akasthan]

Hello,

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 and none of 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?

Thanks

Akash

[v-cazheng-msft]

Hi @akasthan 

I noticed that you have submitted the same issue here DataFormat.Error: Duplicate name - Microsoft Power BI Community. Based on the information from you, I think you need 1:1 troubleshoot by open a support ticket. 

Best Regards,

Community Support Team _Caiyun

[akasthan]

Thanks @v-cazheng-msft 

I was looking for a way to get additional support. Raised a support ticket.