cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
akasthan
Microsoft
Microsoft

DataFormat.Error: Duplicate name

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-1634928741514.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-1634929544316.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.

Is there a way to bypass this or there is some issue on cosmos DB side?

3 REPLIES 3
akasthan
Microsoft
Microsoft

Hi @RicoZhou 

Thanks for looking into this. I have already gone through above links to solve the problem but couldnt figure it out yet.

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 it be occuring because of any other issue?

RicoZhou
Community Support
Community Support

Hi @akasthan 

I think get data from ItemInsightsV2 will show you many Records. There may be duplicate names 'privacyEntityType' in same record. So this will cause error. I sugget you to check column names in your data source and rename duplicate names. 

Here is the offical blog about how to get data from Azure Cosmos DB.

For reference: Visualize Azure Cosmos DB data by using the Power BI connector

And you may refer to this post with similar problem like yours.

For reference: JSON Record with Duplicate Column Names: DataFormat.Error: Duplicate name 'value'.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @RicoZhou 

Thanks for looking into this. I have already gone through above links to solve the problem but couldnt figure it out yet.

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 it be occuring because of any other issue?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.