How to update mongosqld system variables?

I want to change the default value of max_num_global_tables. I followed this document https://docs.mongodb.com/bi-connector/master/reference/system-variables#setting-system-variables. And as mentioned I installed MySQL client, connected to bi connector, and used set global max_num_global_tables=10000; and then I connected MySQL again. Now I checked show variables; and it’s showing the updated value for max_num_global_tables. Now I restarted the bi connector inorder to re-map the DBS but then the value went back to the default value. So how can I change it in bi connector itself? (because the default value is 4000, its not mapping all the dbs and collection we have in mongo)

I have posted a question in stackoverflow for the same with more info: https://stackoverflow.com/questions/64980979/mongodb-bi-connector-not-able-to-update-max-num-global-tables-system-variable/65025395