The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
hello Community
I am trying to use the Azure Cosmos DB V2 connector to get into PowerBI data from a Cosmos Graph. I have read the various articles (including https://learn.microsoft.com/en-us/power-query/connectors/azure-cosmos-db-v2).
My Graph looks like this
I am connecting ok, but once I get the data on the PowerBI side, I am not capable to expand the custom fields (so I only see the label, id, partitionKey)
I tried in Import mode as well as Direct mode (Direct mode is what I ultimately need).
When using the legacy Azure Cosmos DB V1 I do not have a problem, but V1 does not allow Direct Mode which is what I need to do.
Can anyone provide any hint on what I am missing?
cheers
Anca