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
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors