Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
Hi @Anonymous ,
Could you please tell me the language of your Azure and PowerBI?
Best Regards,
Teige
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |