I have a problem with mongodb connection to PowerBi. I downloaded connector to Bi, ODBC. Let’s start from the begging:
I set up local instance of mongodb with all things I needed to connection to PowerBi and it worked.
I created DNS through ODBC and connected to localhost.
Now I try to do the same but on server. I am at the moment where I have working instance of mongodb on server and I can connect to it using my workstation by typing in compass IP of my server and port number. I configurate mongobd.cfg bindIp to my server IP (Or should I change it for my workstation IP. I don’t know if it matter but the connection is still working so… ). So I guess connection is working. But here start a fun part, when I try to do ODBC and make confing by setting name of db, giving it IP address and ports it tries to connect and crashes, no error no nothing just program not responding. I do not have any user created on mongo instance because it was not a big deal in the localhost instance. I will be happy for any help I will get from you guys. Thank you for any help!