Forum Discussion
Fabric Data Engineering Cosmos Mongo DB source
I've just done this however, I had to put it under Synapse as FAbric is not an option.
Anonymous Thanks but that dosen't answer my question.
The fabric Cosmos connector is for the No-SQL version of Cosmos, not the Mongo version and the native mongo connectors will not connect to a Cosmos Mongo Analytics Store.
I have managed to hack this but properly supported connection (in the same manner as Synapse) would be more benificial.
Here the start of my M query
Blank Query
let
Source = DocumentDB.Contents("https://<cosmosMongoAccountName>.documents.azure.com:443/", "<cosmosMongo DB Name>", "<collection name>"),
#"Expanded Document" = Table.ExpandRecordColumn(Source, "Document",<list out the fileds here>
I am having the same issue where I was able to use the MongoDB API in Data Factory and Synapse but it was not available in Fabric. Could you please post the instructions on what your hack was, or possibly make a video on it? It would be a great help
Hi .
Its already in the above post.
New DataFlow Gen2
Blank Query
Start with this...let
Source = DocumentDB.Contents("https://<cosmosMongoAccountName>.documents.azure.com:443/", "<cosmosMongo DB Name>", "<collection name>"),
#"Expanded Document" = Table.ExpandRecordColumn(Source, "Document",<list out the fileds here>Thanks NickA01 . Yesterday, I was playing around with this a bit and it turns out you can use the MongoDB default connector as well in Fabric, in place of the Azure CosmosDB for MongoDB connector that I have been using in Synapse and Data Factory, like you have
could you please suggest how you did this? Did you use https://<cosmosMongoAccountName>.documents.azure.com:443/ or https://<cosmosMongoAccountName>.mongo.cosmos.azure.com:443/ as a server name?
how do you use that, I'm getting the error: The data source kind doesn't support the credential type. Data source kind: DocumentDB. Credential type: UsernamePassword.
