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
Power BI tutorial for Azure Cosmos DB | Microsoft Learn
It seems like a known limitation for using v2 version.
The V2 connector doesn't support complex data types such as arrays, objects, and hierarchical structures. We recommend the [Fabric Mirroring for Azure Cosmos DB](/articles/cosmos-db/analytics-and-business-intelligence-overview.md feature for those scenarios.
You can use fabric mirroring however the only supported auth method is Key based.