cancel
Showing results for 
Search instead for 
Did you mean: 

Error connecting PowerBI with Azure Cosmos DB

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'"

 

akasthan_0-1635360351552.png

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".

akasthan_1-1635360370593.png

 


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

Status: Investigating

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

 

 

Comments
v-cazheng-msft
Community Support
Status changed to: Investigating

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
Microsoft

Thanks @v-cazheng-msft 

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