Forum Discussion

NickA01's avatar
NickA01
Icon for Resolver III rankResolver III
2 years ago
Solved

Fabric Data Engineering Cosmos Mongo DB source

Hi All:  I've started work on a project where the data is in a Cosmos Mongo DB ( RU) account.   I've managed to get connectivity working in synapse but I'd very much like to use Fabric Data pipel...
pipelines
Tips and Tricks
  • NickA01's avatar
    NickA01
    2 years ago

    I've just done this however, I had to put it under Synapse as FAbric is not an option. 

     

NickA01's avatar
NickA01
Icon for Resolver III rankResolver III
2 years ago

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> 

Marusyk's avatar
Marusyk
Icon for Advocate II rankAdvocate II
2 years ago

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.