I am trying to connect to MongoDB using Power BI. By following the steps for the "Connector for BI". I am able to get everything to work if everything is on my local machine, but when trying to set up a DSN for a database on a server, the DSN set up cannot recognize the databases on that server. The error I get (both on the ODBC set up dialog and the mongosqld log) is -
handshake error: ERROR 1043 (08S01): error using database mydb: ERROR 1049 (42000): Unknown database 'mydb'
I have tried running mongosqld with and without "--sampleNamespaces" and in both cases, the log seems to indicate that the schema has been parsed correctly -
2022-09-05T11:57:39.292-0400 I SCHEMA [sampler] mapped schema for 152 namespaces: "mydb" (24): ["mycollection",...