Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

MongoDB Atlas for Pipeline Connection Options in URL

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?  

 



Need Help
Pipeline

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous ,

     

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.