Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Change an Object to string

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.

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi TeigeGao 

       

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

      • TeigeGao's avatar
        TeigeGao
        Solution Sage

        Hi Anonymous ,

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

        Best Regards,

        Teige