Connect to MongoDb from Data Pipeline in Microsoft Fabric

[Marusyk]

I'm trying to connect to MongoDb and got this error

Failure happened on 'Source' side. ErrorCode=MongoDbUnsupportedUuidType,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The wrong representation type of UUID in Binary JSON.,Source=Microsoft.DataTransfer.Runtime.MongoDbV2Connector,''Type=System.FormatException,Message=The GuidRepresentation for the reader is CSharpLegacy, which requires the binary sub type to be UuidLegacy, not UuidStandard.,Source=MongoDB.Bson,'

Here I found that to fix it,  I need to add the uuidRepresentation=standard option in the MongoDB connection string.

But how to do that in Microsoft Fabric if there is no place where put extra options?

Please advice

[Marusyk]

The support ticket remains unresolved, and it has been more than 2 months.

However, I've discovered an interesting case: the error occurs specifically in the Germany West Central region. When I provision the capacity in the West Europe region, for example, everything works fine.

The problem is that all my production workloads are in the Germany West Central region, so I need to use that region for various reasons

[v-nikhilan-msft]

Hi @Marusyk 
Thanks for using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this. We will update you once we hear back from them.
Thanks

[Marusyk]

It is critical one, so here is the support ticket TrackingID#2406140050003006