Change an Object to string

[Anonymous]

I'm very new with working with Cosmos DB. 

I've connected to our Cosmos DB and extracted the columns I need. But my ID column is showing wierd letters.

I've checked in the Cosmos DB and see that the column is an object, how is it possible to change this object to a string in powerbi?

This is what it's currently showing me in PowerBI:

This is how the ID is in our Cosmos DB:

"_id" : ObjectId("5c613dfa6385121416f7dc10"),
	"date" : {

Thanks for the help.

[TeigeGao]

Hi @Anonymous ,

For Json object stored in Azure Cosmos DB, we need to switch to the Power BI Query Editor window, then click on the expander at the right side of the Document column header.

For more information, please refer to this document: https://docs.microsoft.com/en-us/azure/cosmos-db/powerbi-visualize

Best Regards,

Teige

[Anonymous]

Hi @TeigeGao 

I've already done that. This is the colomn that came out of the DB. 

[TeigeGao]

Hi @Anonymous ,

Could you please tell me the language of your Azure and PowerBI? 

Best Regards,

Teige

[Anonymous · Accepted solution]

Hi @TeigeGao 

I found a fix for my issue in the following topic:

https://community.powerbi.com/t5/Desktop/Can-t-read-from-Azure-Cosmos-DB-because-ObjectId/td-p/39901...