MongoDB Atlas for Pipeline Connection Options in URL

[r_Gao]

Hi!
Today i tried to include options in my MongoDB Atlas for Pipeline Connection in Microsoft Fabric because i require to read data from an analytics node. However when I include it in my url and test the connection in my copy activity it fails with the error message: The server url '<server>/?readPreferenceTags=nodeType:ANALYTICS&readPreference=secondary' is invalid, options are not allowed in url.  Is there a way to do this?  

[r_Gao]

So in this case do we have no choice but to make connections on the primary node? This is a huge issue for us as we do not want to degrade performance of the mongo database while doing our reads. 

[lbendlin]

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

[v-kongfanf-msft]

Hi @r_Gao ,

The connection string format used for MongoDB Atlas in the replication activity does not appear to support including options such as readPreferenceTags directly in the URL.Power BI may restrict certain options in the connection URL to simplify configuration, and adding parameters may result in validation errors.

Refer to the following documentation on configuring connection information:

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.