Forum Discussion
Advocate IAzure Cosmos DB v2 not parsing JSON arrays
Conlyn this is a known issue with the connector, and there is a workaround to manually update the script of the Azure Cosmos DB/JSON source to get the map data type support. Kindly read this Microsoft article :
https://learn.microsoft.com/en-us/azure/data-factory/data-flow-troubleshoot-connector-format
More also ensure that you are using the latest version
Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!Let me know if this work
@ me in replies or I'll lose your thread!!!Thanks
Advocate IDallasBaba The solution in that MS article is for updating a script in Data Factory (DSL), and not for the PowerBI Power Query M language. I'm not seeing how I can define a schema from the results that come back when defining the source from CosmosDB.Contents(xyz) in Power Query.
-Conlyn
Hey Conlyn, I am in the same situtation and was wondering if you have any leads in regards to the same query you mentioned above.
- Conlyn
Hi Anonymous, it looks like there is an updated beta version of the v2 connector out now, but we haven't tried it yet, https://learn.microsoft.com/en-us/power-query/connectors/azure-cosmos-db-v2.
We ended up utilizing a Cosmos ODBC driver on our data gateway for PowerBI.