Hi @shan-databricks ,

Try to use dedicated access mode instead of standard (shared). Probably mongodb connector requires access to some API which is blocked in standard access mode (i.e data source v2), but is allowed in dedicated access mode. 

If my answer was helpful, please consider marking it as solution