How to connect to Mongo DB via ODBC connection on PowerBI service
My data source is locating in MongoDB (I have still yet checking with the vendor whether MongoDB is located in Atlas or somewhere on the premise)
On Power BI service, I would like to create a dataflow, then get data from MongoDB via ODBC connector.
May I ask anyone know what exactly should I fill in the follwoing so that I will be able to connect to the data source?
sorry I am a newbie to ODBC connection and MongoDB.
ODBC connection string (anywhere should I find this / I should be able to attain this from the vendor) On-premises data gateway (where should the data gateway be created? at the location where the mongo DB situates?) Authentication kind (what should i fill in)